Lookup Selectbox variable showing all choices in Catalog UI Policy conditions

[peter_repan]

Hi all,

I have record producer with Lookup Selectbox variable called category referencing to sys_choice table and with a help of reference qualifier the variable is showing only few choices in the form. 

The issue is: if I would like to create a Catalog UI Policy on the Record producer for that variable, the "Catalog Conditions" are showing for category variable thousands of records from sys_choice table.

It's pretty much killing the performance of the Catalog UI Policy page and it's as well hard to find the correct choice in case of duplicate names.

Any ideas how to apply the reference qualifier from variable also in Catalog Conditions field?

[Michael Fry1]

There is an option to show unique values only. Is that checked?

[peter_repan]

Hi Michael,

thank you for hint, it will remove duplicate values however the list in Catalog UI Policy is still showing all records from sys_choice table 

[Michael Fry1]

Can you post a screen shot of your variable setup? The sys_choice table will return all choices, are you using a ref qualifier to limit the results?

[peter_repan]

yes, I'm using reference qualifier. See picture below: