- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-30-2019 01:29 AM
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
Solved! Go to Solution.
- Labels:
-
Service Catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-30-2019 03:01 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-30-2019 03:50 AM
Ok, Have you tried using 'label' instead.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-30-2019 04:08 AM
Thanks again for the help provided!
It was something that I personally missed in the query and that's why it didn't work. I noticed the issue when I just went to the Choice table and created the filter manually in the list view.
Reference qual: javascript: 'name=change_request^element=u_subcategory^dependent_value=Business Systems'
Variable Attributes: ref_qual_elements=Business Systems
I will mark your answer correct so other in the same situation will see the solution!
best regards,
Bogdan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-30-2019 04:09 AM
Glad it helped!!