How do I compare two reference field value?

[Sid_Takali]

Hi all,

I have a scenario where I have to create Relationship in two tables (Related List). Applies to table is "Case" and Queries from table is "Custom" Table. There is a common reference field in both the table and that refers another table. So how do I compare a reference field from "Case" Table and "Custom" table. 

Thanks

[Omkar Ranjane]

Hi @Sid_Takali 

Lets say field name on custom table is "u_parent" which refer the case record.

Applies to table [Select the table on which the related list appears] : Case

Queries from table [Select the table from which this related list retrieves data] : Custom

Query with : current.addQuery('u_parent', parent.sys_id.toString()); // here parent means Applies to table

If your question is solved, please close the topic by marking my answer "Accept as Solution". This will help others searching for a similar question and will remove the topic from the unsolved list.

[Muhammad Khan]

Try with below script.

(function refineQuery(current, parent) {

	// Add your code here, such as current.addQuery(field, value);
	current.addQuery('common_reference_field_backend_name', parent.getValue('common_reference_field_backend_name'));

})(current, parent);