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

[Pavankumar_1]

Hi @Sid_Takali ,

you are planning to get the custom table records which is using case and show those specific records on cases related list.

(function refineQuery(current, parent) {
    current.addQuery('casereferencefield', parent.sys_id); //give the case rference filed name which is on custom table.
})(current, parent);

[Sid_Takali]

Hi @Pavankumar_1  Thanks for your prompt response. 

but the thing here that the common field between these two tables is reference field, no other field is common in between. There is no parent field on custom table.

Thanks

[Pavankumar_1 · Accepted solution]

Hi @Sid_Takali ,

Yes I got it. You have the case table and custom table. custom table the case reference field and case table has the custom table field.

we can display related data on custom table which is using on case and vice versa.

[Community Alums]

Hi @Sid_Takali ,

You can refer to these links :

https://www.servicenow.com/community/developer-forum/two-tables-field-value-comparing/m-p/2034941

https://www.servicenow.com/community/us-ne-nebraska/how-to-compare-catalog-reference-variables/m-p/3...