- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2025 11:07 PM
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
2. Subcategory
What changes do I need to make to achieve the goal?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2025 05:24 AM - edited 06-05-2025 05:25 AM
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();
Subcategory Variable Config:
Output: English user category, subcategory dependency working fine
It should work the same if Language is Spanish
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2025 11:17 PM
in the reference qualifier try to get logged in user language and use that filter to show relevant language choices
Did you try that?
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2025 11:20 PM
are you saying spanish user is seeing English choices also?
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2025 03:51 AM - edited 06-05-2025 03:52 AM
I just 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2025 03:59 AM
Did you try to do what I mentioned above? to get logged in user language and use that in ref qualifier?
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader