Using multiple catalog variable values ( 3 lookup selectboxes), filter the list to display for 4th lookup select box

SuneelG
Kilo Guru

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

1 ACCEPTED SOLUTION

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

View solution in original post

3 REPLIES 3

Jaspal Singh
Mega Patron
Mega Patron

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

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

Great. Kindly close the thread by marking appropriate answer as correct so that it does not appear in unanswered list.