How to display unique value in reference field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-21-2022 12:03 AM
Hi All,
i have a reference field(ci class)>referencing "u_ci_class_lookup". This reference field is having duplicate records. how to remove this duplicates.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-21-2022 12:07 AM
You have to build ref qualifier, and through script include you need to pass on the list of unique ci class sys_ids.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-21-2022 12:13 AM
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-21-2022 02:39 AM
@sachin g k
Feel free to Mark Correct, for convenience of future users.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-21-2022 12:10 AM
Hi Sachin,
Go through this link. Mark my answer as correct if that helps.
https://community.servicenow.com/community?id=community_question&sys_id=b073b02adb366380afc902d5ca9619e1
