Set_query problem!

[NCP]

Please check this.

References:

Set filter to link based on another field (In a child table)

Hi @Nabyar, It’s worked properly. frappe.ui.form.on('Payment Entry', { refresh: function (frm){ frm.set_query("reference_name" ,"references", function (doc, cdt, cdn){ let row = locals[cdt][cdn]; return { filters: [ [row.reference_doctype, 'docstatus', '=', 1], [row.reference_doctype, 'company', '=', frm.doc.company], [row.reference_doctype, 'customer', '=', frm.doc.party_name], …

Display the list of ALL CONTACTS of a customer on Quotation or Invoice document

That for, you have to apply the client script for quotation and sales invoice doctype. Here i provide the client script for the quotation. frappe.ui.form.on("Quotation", { refresh: function(frm) { frm.set_query("contact_person", function(){ return { "filters": [ ["Dynamic Link", "link_doctype", "=", "Customer"] ] }; }); } }); Please also set the script for the sales invoice. Then reload Ctrl+S…

Show particular list

Are you talking about the child table filter? [image] Then apply it frappe.ui.form.on('Test DocType', { refresh: function(frm) { if (frappe.session.user == "user1@testmail.com") { frm.set_query("item", "test_child_table_1", function () { return { "filters": { "item_group": "Products" }, }; }); } } });

How to fetch item in specific item group

Hi @amal_31845, Please check the documentation of the Overriding Link Query By Custom Script. Lots of examples are already available in the forum so please search like frm.set_query frappe.ui.form.on('DocType', { refresh: function(frm) { frm.set_query("item_code", function() { return { "filters": { "item_group": frm.doc.item_group } }; }); }, }); Please set the doctype name and field name.

Item group based on items filter in sales invoice doctype

Hi @D_Haritha, You have to apply the logic item group, and again check the reference and documentation. And lots of examples are in the Forum so search for it frappe.ui.form.on('Sales Invoice', { refresh: function(frm) { frm.set_query("item_code", "items", function (doc, cdt, cdn) { var row = locals[cdt][cdn]; return { "filters": { "item_group": row.item_group }, }; }); } });