Remove duplicate value from reference type field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2023 04:29 AM
Hello,
How to remove duplicate value from reference field using advanced reference qualifier in ServiceNow? Kindly help.
Thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2023 04:51 AM
Hello,
Please check the below post:-
Please mark my answer as correct based on Impact.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2023 09:43 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2023 09:45 PM
I agree with point mentioned by Manmohan.
Please discuss the same and share the updates.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-08-2023 03:19 AM
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.