- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2020 12:42 AM
I have a table with multiple columns and out of which 8 are
Col1 Label | Col1 Value | Col2 Label | Col2 Value | Col3 Label | Col3 Value | Col4 Label | Col4 Value |
In Catalog Item, I created 4 Lookup Select Box variables and each one uses one each column from the above same table
=> Lookup Select Box 1 -- uses -- Col1
Lookup Select Box 2 -- uses -- Col1
Lookup Select Box 3 -- uses -- Col1
Lookup Select Box 4 -- uses -- Col1
For the combination of col1 AND col2 AND col3 , there can be one or more values available in the table records.
I am able to use "reference qualifier" and "variable attributes" using "any one" column value
Ex:
If variable name for lookup select box 1 is => envtype
Reference Qualifier: javascript:'u_col1_value='+current.variables.envtype
Variable attributes: ref_qual_elements=envtype
Now I want to modify this to accommodate col2 and col3 values to further narrow down the list for col4
I tried the following to add col2 by updating Reference Qualifier and Variable Attributes:
Reference Qualifier: javascript:'u_col1_value='+current.variables.envtype^'u_col2_value='+current.variables.prodtype
Variable attributes: ref_qual_elements=envtype;prodtype
The updates did not help in adding col2 in the query to filter. I think "Reference Qualifier" update may be the problem.
The link: https://docs.servicenow.com/bundle/jakarta-servicenow-platform/page/use/using-lists/concept/c_Encode... gives example for one column condition.
Is it possible to achieve my requirement using the above technique OR do I need to use Script Include & Client Script to achieve this?
My table will not have not more than 100 rows. Is there any performance issue I need to consider when using the above options?
Thanks in advance,
Suneel
Solved! Go to Solution.
- Labels:
-
Service Catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2020 02:13 AM
Hi Jaspal,
Thank you for the reply. I made one more modification to get it working:
Changed:
javascript:'u_col1_value='+current.variables.envtype'^u_col2_value='+current.variables.prodtype
To:
javascript:'u_col1_value='+current.variables.envtype+'^u_col2_value='+current.variables.prodtype
Thank you for point me in right direction.
-Suneel

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2020 12:50 AM
Hi Suneel,
It should work unless you have a typo as below.
javascript:'u_col1_value='+current.variables.envtype^'u_col2_value='+current.variables.prodtype
should be
javascript:'u_col1_value='+current.variables.envtype+'^u_col2_value='+current.variables.prodtype
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2020 02:13 AM
Hi Jaspal,
Thank you for the reply. I made one more modification to get it working:
Changed:
javascript:'u_col1_value='+current.variables.envtype'^u_col2_value='+current.variables.prodtype
To:
javascript:'u_col1_value='+current.variables.envtype+'^u_col2_value='+current.variables.prodtype
Thank you for point me in right direction.
-Suneel

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2020 02:45 AM
Great. Kindly close the thread by marking appropriate answer as correct so that it does not appear in unanswered list.