Help
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Multi Row variable set introduced in London version not compatible with Lookup field's Reference qualifier

ajitmundhekar
Tera Expert

Area: Service Catalog

Component: Multi-Row Variable Set

Version: London

Requirement: 

Multi-Row Variable set has a two variables of type "Lookup Select Box". The dropdown list of 2nd fields should be displayed depending on the option selected in 1st field. Accordingly, 2nd field's configuration is as follows:

Reference qualifier: javascript: 'first_field_name='+current.variables.first_field_name;

Variable attributes: ref_qual_elements=first_field_name

Issue:

2nd field does not considers the options which is selected in 1st field after form is loaded. It always considers the default selected option of 1st field which is set at the time of form load.

PS: Above configuration works perfectly with Single-Row Variable set.

Thanks & Regards,

Ajit Mundhekar

11 REPLIES 11

Jace Benson
Mega Sage

So I was wondering about this since I read it. 
I had to give it a try and I have to say you're really close.

That feature 'ref_qual_elements' is really buried in the docs but here's what I did to set it up and get it to work.

  1. I created a multirow aka table variable set called "multirow_variable_set" with 4 questions with four questions but for this I just used 2. 
  2. On my string variable called "question_2" I don't have to do anything
  3. On my reference variable called "user" set the reference qualifier to "javascript: 'emailSTARTSWITH' + current.variables.question_2;"
  4. Also on the reference variable called "user" set the variable attribute to: "ref_qual_elements=multirow_variable_set"

With all that if you need more, information let me know. 

Multirow variable sets in my opinion are weird how they work, cause onchange client scripts are weird cause I can't get them to work.

Thanks for the reply Jacebenson.

But it is still not working for me after updating variable attributes to 'ref_qual_elements=multi_row_vs' //'multi_row_vs' being my Multi row variable set name.

Also, wanted to add up that my "User" field is actually of type "Lookup Select Box" & not "Reference".

Let me know if your approach also works for "Lookup Select Box" type fields.

Thanks & Regards,

Ajit Mundhekar

mine is also lookup select box.  Um. I'll leave this here you can check it out.

here's a link to my pdi with it working:

Instnace: https://dev68829.service-now.com

login; slack

pass; slack

Link to the item definition: https://dev68829.service-now.com/nav_to.do?uri=sc_cat_item.do?sys_id=c8358f12db3223008096a455ca9619d...

Link to the variable set: https://dev68829.service-now.com/nav_to.do?uri=item_option_new_set.do?sys_id=d689d0e30f2b5300fc69cdb...

Link to the lookup select box: https://dev68829.service-now.com/nav_to.do?uri=item_option_new.do?sys_id=38a54bd2db3223008096a455ca9...

Link to the item in service portal: https://dev68829.service-now.com/sp?id=sc_cat_item&sys_id=c8358f12db3223008096a455ca9619da

Link to the item in UI16: (appears this doesn't work for this.)

ajitmundhekar
Tera Expert

Hi Jace,

The login credentials that your provided are not working for dev68829.

Thanks,

Ajit Mundhekar