Filter child table

Frappe Framework Customization
1

hello, I’m having trouble filtering child tables, where I have factor and parameter fields
like the picture below:

RR3
RR3828×364 8.34 KB

RR2
RR2773×527 29.1 KB

RR
RR774×232 12.2 KB

2

have you found the solution? if yes please describe i also facing the issue.

1 Like
3

Use Something Like this

frappe.ui.form.on("Quotation", "refresh", function(frm) {
    frm.fields_dict['items'].grid.get_field('item_code').get_query = function(doc, cdt, cdn) {
        var child = locals[cdt][cdn];
        //console.log(child);
        return {    
            filters:[
                ['Item', 'item_group', '=', child.item_group]
            ]
        };
    };
});
3 Likes
4

thankyou, very helpful for me

5

The stander way to do it is using set_query

frm.set_query("items","item_code", function(){
       return {
              filters:[
                ['Item', 'item_group', '=', child.item_group]
            ]
       }
})

This also handle empty filter value