How to apply filter to child table link fields

ERPNext
, ,
1

I have a long list of Items, some of them are service lists and some are equipments. Whenever we prepare a quotation the quotation items child table fetches from all the item lists. In our case we only use service items for quotation, If there’s a way to apply a custom filter to show only service items from servies item group in quotation form it’ll be great

image
image673×537 33.5 KB

Thanks,

2

Hi @girumtibebu,

That for, please apply the client script for Quotation.

frappe.ui.form.on('Quotation',  {
    refresh: function(frm) {
        frm.set_query("item_code", "items", function (doc, cdt, cdn) {
          return {
            "filters": {
              "item_group": "Services"
            },
          };
        });
    }
});

Output:

image
image1825×742 84.7 KB

Thank You!

2 Likes
3

@NCP Thank you!.
Just curious on how the filtering works performance wise, does it cache all the items first and do filtering locally? How many requests does it make to the database?

4

Hi @girumtibebu,

Please check the documentation of Overriding Link Query By Custom Script.

I hope this helps.

Thank You!

1 Like
5

Great. That cleared it out for me.
Thanks.