Lookup Select Box service catalog variable Reference qual

[Bogdan18]

Hi everyone,

So I have a Lookup Select Box variable on a catalog item which is looking for the choices of the Subcategory field from the Change Request form. The Subcategory field is a string field with Choices defined and they have a dependency on the Category values.

I also set the Variable attributes to ref_qual_elements=Business Systems.

The thing is that the above doesn't work. If I look at the variable in my catalog item form I see all of the choices from the Subcategory field. I just want to see the ones depended on Business Systems. I could create a script include and a Catalog Client Script but I think this is too much for such a simple reference qual?

Any ideas why this would not work and any suggestions on hot to make it work?

thanks,

Bogdan

[Omkar Mone]

Hi 

What is the dependent_value? Is it a variable?

[Bogdan18]

It's the Dependent value of the Subcategory field Choices from the Change Request form.

So I only need these 11 choices to be displayed in my Lookup Select Box variable from my catalog item

[rad2 · Accepted solution]

Hello,

This the filtering is on the choice table. maybe you can create a lookup select field on sys_choice table and filter with the table - change_request and element - subcategory and dependent_value - Business Systems options

ex - 

javascript: 'name=change_request^element=subcategory^dependent_value=business_systems';

I have created a test one with following details

table - change_request

field - category

language - es

[Bogdan18]

Hi there,

That sounds like a good way of getting the desired Choice values. Thanks for the suggestion!

Could you please let me know how the ref_qual_elements should look like? I have set it up to ref_qual_elements=Subcategory, ref_qual_elements=u_subcategory... and it's still not working.

Without the ref_qual_elements I don't get any results in the drop-down.

Thanks,

Bogdan