Apply filter on child table based on parent doctype field

[Mohtashim_Shoaib]

APPLY FILTER ON CHILD TABLE BASED ON PARENT DOCTYPE FIELD
PARENT TABLE

CHILD TABLE

[antzforwork]

Hi @Mohtashim_Shoaib i think you can use js script to achieve it.
I don’t think menu on Doctype can handle it…

Here some references :

How to Filter child table

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 fiel…