How to show unique values on a reference field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2023 09:13 AM
I have the field 'site' type reference to u_sites table on the incident table. In u_sites table i have two columns:
1) site name (display = true)
2) site location
In this table i have multiple sites with the same name but with a difference location.
When the user search for a site from the incident table, he see the same site name multiple times, for example:
Alon
Alon
Alon
How can I make sure that he will only see unique names (Alon will appear only once even though each 'site name' has a different location)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2023 09:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2023 09:24 AM
Check this thread, similar post is answered here.
Solved: How to display only unique values from the Referen... - ServiceNow Community