How to filter unique reocrds in a table??

Jitu Kumar
Tera Contributor

‎05-06-2022 07:58 AM

Hi,

I have a custom table name "Contractual". Which has Home field which is a reference field of a other table denomination whose fields are Name , Role, Country. 

I want to get unique value of name should be visible when I click home button on Contractual table.

 

Can anyone suggest which filter condition shall I mention to get these requirement or do I need to write script for this. If yes, what and where? 

Labels:
Preview file
21 KB
0 Helpfuls
  • 1,670 Views
5 REPLIES 5

Chetan Mahajan
Kilo Sage
Kilo Sage

‎05-06-2022 11:25 AM

Hi Jitu,

                Please go through below script you have to create advance reference qualifier and need to call script include there, just change your table name in script include it will work for you. 

https://community.servicenow.com/community?id=community_question&sys_id=b073b02adb366380afc902d5ca96...

Kindly mark correct and helpful if applicable

0 Helpfuls