How to Filter child table

Frappe Framework Customization
10

Hello @Vajra, you may try something like this:

frappe.ui.form.on("Delivery Note", "refresh", function(frm) {
    frm.fields_dict['items'].grid.get_field('CHILD_FIELD_NAME_TO_BE_FILTERED').get_query = function(doc, cdt, cdn) {
        var child = locals[cdt][cdn];
        //console.log(child);
        return {    
            filters:[
                ['IS_IT_OK_FIELD', '=', child.CHECKBOX_FIELD]
            ]
        }
    }
});

In my example child field is Batch. So “IS_IT_OK_FIELD” is a field on my Batch doctype. “child.CHECKBOX_FIELD” is a field on a delivery note item grid.

2 Likes