Duplicate Values in catalog down down menu

B V
Tera Contributor

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?

5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron

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]

****************************************************************************************************************

BalaG
Kilo Sage

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

Screenshot 2024-02-10 at 9.58.45 AM.png

 

If this answer solved your issue please mark it as a solution or mark it 👍 helpful if it was of help.

--

Bala Guthy

Shivam Techlene
Tera Guru

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.

tempsnip.png

 

 

 

 

 

 

 

 

Please mark my response as helpful and correct if it resolves your requirement.

 

Thanks & Regards,
Shivam Jaiswal

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.

 

Thanks & Regards,
Shivam Jaiswal