How to apply filters differently in two same child table in same parent doctype?

ERPNext
, ,
1

I have child table Doctype-name “Input Table”. I have used this child table twice in the parent doctype name “Three PL”.
The child tables’ fieldnames are as input_1 and input_2. But When I apply filters differently to both child tables field “key”. Filter are not different but are same of last child table has used. Key field is of select datatype

2

You can use frm.set_query.

3

But I am applying select datatype not link datatype.

4

If you want to set options in a select element, you can use this.

frm.fields_dict.input_1.grid.update_docfield_property("field_name","options",["Option 1", "Option 2", "Option 3"]);

frm.fields_dict.input_2.grid.update_docfield_property("field_name","options",["Option 4", "Option 4", "Option 6"]);
5

frm.fields_dict['create_order_input'].grid.update_docfield_property('key', 'options', frm.vendor_order_fields);

I am using this .

6

Is it working?

7

nope not working

8

Have you tried the solution I shared with you? It’s working for me.

9

still nope as both child table are of same doctype.

10

Here, input_1 is the field name which is in the parent DocType. Have you replaced it with your parent DocType’s field name?

11

yep i replaced it