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? 

[Pratiksha KC]

@Ankur Bawiskar 

did you try adding alert inside the script and see? yes. Alert is also not working

Are you checking with english user? Yes.

[Ankur Bawiskar]

@Pratiksha KC 

unless your condition satisfied alert won't come.

Did you add alert in both the script section?

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

[Pratiksha KC]

@Ankur Bawiskar 

Did you add alert in both the script section? - Yes. 

Still not working. Is there any other way?

[Ankur Bawiskar]

@Pratiksha KC 

try with onChange client script and see what value comes in alert when that variable changes

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

[Pratiksha KC]

@Ankur Bawiskar 

Below onChange client script worked 

function onChange(control, oldValue, newValue, isLoading) {

    if (isLoading || newValue == '') {

        g_form.setVisible('u_vulnerability_severity_level', false);

        return;

    }

    if (newValue === 'Vulnerability') {

        g_form.setVisible('u_vulnerability_severity_level', true);

    } else {

        g_form.setVisible('u_vulnerability_severity_level', false);

        g_form.clearValue('u_vulnerability_severity_level');

    }

}

But why it was not simply worked with UI Policy script ?