Set specific values in a field type Link

ERPNext User Forum
1

Hello everyone, I am new using frappe erpnext, I have a link type field that points to the Doctype Countrys, but I need to select only one type of data to show only the countries that have that associated data. Since not all countries have that additional information.

Thank you for your kind help.

2

You can add a filter via Javascript:

cur_frm.fields_dict.FIELD_NAME.get_query = function(doc,cdt,cdn) {
		return {
			filters:[
				['ASOCIATED_DATA_FIELD_NAME', '=', "VALUES"]
			]
		}
	}

You can replace the condition whit other that fit your case, for example “in” (in which case you should provide a list of values in “VALUES”), or “!=” or others.

1 Like
3

In Doctype principal I have a field that focus on Country doctype, but in the doctype country I have a child table with the aditional information, In this case i need that show only the country name that have data in the child table.

4

Try with “!=” and null:

['ASOCIATED_DATA_FIELD_NAME', '!=', null]
2 Likes
5

Thanks for you kind help

1 Like