Duplicate Values in catalog down down menu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-09-2024 12:47 PM
I'm creating a catalog item that is referencing the location table to the street field for a location lookup. We have multiple locations that have the same street address. How would I remove the duplicate street values in the drop down list on the catalog item?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-10-2024 09:17 AM
Hi @B V
If locations has same street then it is data, if you need to remove this, it will be high customization, as you need to run a loop to check the values and remove if duplicate or show only unique.
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-10-2024 10:05 AM
Hello @B V you can eliminate duplicates by selecting "unique" checkbox in the "Type Specification" section of Variable edit form in platform UI. You can find the catalog variable by following
All -> Service Catalog -> Catalog Variables -> Item Variables
If this answer solved your issue please mark it ✅ as a solution or mark it 👍 helpful if it was of help.
--
Bala Guthy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-10-2024 10:18 AM
Hi @B V ,
There is a check box named "Unique Values Only" under the type specification section of a variable. You can set it to true to see only unique values. He is a screenshot attached for your reference.
Please mark my response as helpful and correct if it resolves your requirement.
Shivam Jaiswal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2024 02:59 AM
Hello @B V ,
Did you get a chance to try this one?
Please mark my response as helpful and correct if it resolves your requirement.
Shivam Jaiswal