JS array of items retrieved in set_query

ERPNext
, ,
1

Let’s say I’m setting a Link filter like below:

refresh: function (frm) {
	frm.set_query('customer', () => {
		return {
			'filters': [['disabled', '=', 0]],
		};
	});
}

I want the customers retrieved in set_query as a JS array.
For example, to do something like this:

frm.set_value('customer', list_retrieved_from_query[0]);

Is there a way I can do this?

Edit: Nvm I can just do a frappe.db.get call

3

try something like this

refresh: function (frm) {
    frm.set_query('customer', () => {
        return {
            'filters': [['disabled', '=', 0]],
        };
    }).then((data) => {
       
        var customers = data.map((customer) => {
            return customer.name; 
        });

        
        frm.customersArray = customers;
    });
}
4

Hi @SvbZ3r0,

Please apply it.

refresh: function(frm) {
    frappe.db.get_list('Customer', {
        filters: { disabled: 0 },
        fields: ['name']
    }).then(data => {
        var customer_list = data.map(d => d.name);
        frm.set_value('customer', customer_list);
    });
}

Then reload and check it.

Thank You!

5

Thank you @yosef @NCP