How to fetch cancelled opportunity documents

ERPNext
, ,
1

Hello,

I am trying to fetch opportunity documents which are cancelled but I am not getting success. What I come across is even when document is cancelled there status is open. See below

image
image1366×588 43.8 KB

So now how I can get document which are cancelled? What are ways?

Below is my simple client script where i am trying…

frappe.ui.form.on(‘Opportunity’, {
refresh(frm) {
frappe.call({
method: ‘frappe.client.get_list’,
args: {
doctype: ‘Opportunity’,
fields: [‘name’],
filters: {
‘status’: ‘Cancelled’
}
},
callback: function(response) {
if (response.message) {
var cancelledOpportunities = response.message;
console.log(‘Cancelled Opportunities:’, cancelledOpportunities);
} else {
console.log(‘No cancelled Opportunities found.’);
}
}
});
}
});

2

Hi @pm23,

Please check the syntax and apply it according to the scenario.

frappe.ui.form.on('Opportunity', {
    refresh(frm) {
        frappe.db.get_list('Opportunity', {
            filters: { 'docstatus': 2},
            fields: ['name'],
            limit: null
        }).then(oppo => {
            oppo.forEach(val => {
                console.log("---------", val)
            });
        });
    }
});

Thank You!

3

@NCP ,

Its working.

Thanks!!