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

[Pratiksha KC]

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? 

[Ankur Bawiskar]

@Pratiksha KC 

I logged in with user with English language and I could see only 4 categories

Is your English user seeing other choices also? -> You didn't answer this question which I asked above?

[Pratiksha KC]

Is your English user seeing other choices also?  - Yes. 

[Ankur Bawiskar]

@Pratiksha KC 

Try to add this in reference qualifier and see if it works, I could see you hard-coded english language in reference qualifier, try to make it dynamic

javascript:'inactive=false^table=incident^element=category^language=' + gs.getsession().getlanguage();

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

[Ankur Bawiskar · 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();

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.

[Pratiksha KC]

Thanks for the reply! I will try this way.