Remove duplicate value from reference type field

Madhurima2
Tera Contributor

Hello,

How to remove duplicate value from reference field using advanced reference qualifier in ServiceNow? Kindly help.

 

Thanks in advance.

4 REPLIES 4

Saurav11
Kilo Patron
Kilo Patron

Hello,

 

Please check the below post:-

 

https://www.servicenow.com/community/developer-forum/how-to-display-only-unique-values-from-the-refe...

 

Please mark my answer as correct based on Impact.

Manmohan K
Tera Sage

Hi @Madhurima2 

 

Instead of adding advanced referenced qualifier, why don't you investigate the reason behind the duplicates in the table you are referencing . If they are true duplicates, then discuss with your team and get the data cleaned up

Ankur Bawiskar
Tera Patron
Tera Patron

@Madhurima2 

I agree with point mentioned by Manmohan.

Please discuss the same and share the updates.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hello Ankur,

 

This field value is associated with different records so we can not cleanup the table. This field value is particularly work as a reference field of a different table.