How to add more filters in items child table's item code?

[Lone_Wolf]

I want to add more filters in items child table’s item code link data, How can I do this?

[Suresh_Thakor]

@Lone_Wolf , This script works. Change according your need.

frappe.ui.form.on("Material Request", 
   cur_frm.cscript.onload = function(frm) {
	cur_frm.set_query("item_code", "items", function() {
		return {
			filters: {"item_group": "ABC"}
		}
	})});

Output

Thanks

[Lone_Wolf]

@Suresh_Thakor Thanks for your reply. I got an error on implementing your given code:

[NCP]

Hi @Lone_Wolf,

Please check the documentation of Overriding Link Query By Custom Script.

I hope this helps.

Thank You!

[Lone_Wolf]

Its working after calling the function from refresh. Thank you everyone.