Filter Link field based on child table value`

[shahid_ecit]

Hi,

I have doctype named x it has link field link and it has data field data and this link field is linked to doctype y and y has child table child this child table has column data same data in x so when ever i enter data i wish to filter link based on the data in child.

That is let

y has 2 rows

1. has title y_1 and it is child table child has data with value shahid
2. has title y_2 and it is child table child has data with value varun

and now i go to doctype x when ever i enter shahid in data field i want to show Y_1 in link.

hope my doubt was clear

can any one help me with this please

[Sangram]

It’s a little bit confusing but looking at your title, you want to add a filter on any of your link fields.
you can use - set_query for it.

e.g.

frm.set_query("fieldname", function() {
			return {
				filters: [/* your filters */]
			}
		}) 

OR

frm.set_query("fieldname", function() {
			return{
				query: "query_path"
			}
		});

you can found many such examples in erpnext/frappe app code.

Also check this - Overriding Link Query By Custom Script

[shahid_ecit]

@Sangram thanks for you help i found the solution with help of you and with this also

Filter link based on child table field on other doctype

Hi, It is possible to filter link field based on child table field on other doctype.? doctype 1: purchase order doctype 2: item In items table in purchase order , im trying to filter the default item_code based on company. In Item doctype, i have created a child table that consist of company and warehouse name. I would like to compare between these two doctype, purchase order and items, if the company in purchase order doctype is in existed in company field in child table at items doctype…

expect help like this in feature thanks