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]

If you change the reference qual to something like this, does it work for UI Policy:

(no javascript needed but do update the scope name)

name=x_hagetcetc^element=u_request_type^inactive=false^dependent_value=ariba

[peter_repan]

I tried but it seems the reference qualifier is not taken into account in Catalog UI Policy. So it did not help.

[Michael Fry1]

If you go to the sys_choice table, and create the same ref qualifier to limit your choices, are you missing anything? do you get single choices?

I have Lookup Selectbox on Choice List and only have single choices in UI Policy but my lookup field is Label, and lookup fields are blank.

[peter_repan · Accepted solution]

Thanks Michael a lot for your hints. 

I finally fixed the issue.

The solution was to remove "javascript:" from the reference qualifier. 

😮 😮 😮

[Michael Fry1]

Nice - glad you got it working.