Wants to remove duplicates from my lookup select box for category and subcategory

Pratiksha KC
Tera Guru

When I use a Lookup Select Box referencing the Incident table and select the category field:

  • It pulls all values from the incident.category field.

  • If you've localized categories (e.g., via the sys_choice table), it shows duplicate entries — like “Hardware” in English, French, German, etc.

  • These are not true duplicates but different sys_choice entries for different languages.

I Wants to remove duplicates from my lookup select box for category and subcategory variables in record producer and also wants to make subcategory dependent on category

 

I have created variable set- 

1. Category

PratikshaKC_0-1749103525721.png

2. Subcategory

PratikshaKC_1-1749103570219.png

 

What changes do I need to make to achieve the goal? 

 

 

1 ACCEPTED SOLUTION

@Pratiksha KC 

With english user I was able to see other choices as well, so now I added this as reference qualifier

It showed me only English.

So you can add that in subcategory as well in the end for language handling

javascript:'inactive=false^name=incident^element=category^language=' + gs.getSession().getLanguage();

AnkurBawiskar_3-1749125791391.png

 

AnkurBawiskar_4-1749125802658.png

Subcategory Variable Config:

AnkurBawiskar_5-1749126023156.png

Output: English user category, subcategory dependency working fine

It should work the same if Language is Spanish

category subcategory dependency language sys choice catalog item.gif

I believe I answered your question. I also attached the gif to this post so that you can pause and see

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

19 REPLIES 19

@Pratiksha KC 

I believe I answered your question.

Please mark my response as correct and close the thread so that it helps members.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar 

 

This solution I tried and it worked but we have another scenario on subcategory 

 

Write a UI policy for dependency - if variable subcategory is selected as 'vulnerability' than u_vulnerability_severity_level field should visible on the record producer.

 

But trying to write UI policy for this, in the condition if we select subcategory is - it showing limited thousand record and not able to found our choice 

 

PratikshaKC_0-1749217762211.png

 

@Pratiksha KC 

then please use client script

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Ankur Bawiskar 

 

I have written a UI Policy script, but it is not working. Could you please look into it?

PratikshaKC_0-1749218555430.png

 

@Pratiksha KC 

did you try adding alert inside the script and see?

Are you checking with english user?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader