Lookup Selectbox variable showing all choices in Catalog UI Policy conditions

peter_repan
Tera Guru

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?

 

find_real_file.png

1 ACCEPTED SOLUTION

Thanks Michael a lot for your hints. 

I finally fixed the issue.

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

😮 😮 😮

 

View solution in original post

10 REPLIES 10

YRK
Tera Contributor

Hi Peter,

I removed the javascript, but the dependent values in my query is dynamic.

Here is my reference qualifier,

"name=sys_choice^inactive=false^element=Oracle ERP Maintenance Request - Change Type^dependent_value="+current.variables.business_function.

 

It is not giving any options for me.