Multi Row Variable Set (MRVS) filter question

[john_duchock]

I have a simple catalog item with a variable "Business Unit" ('business_unit' ; reference: business_unit)

I also have a three-variable multi row variable set:

• Business Unit ('business_unit_mrvs') reference: business_unit)
• Application ('application_choice') reference: cmdb_ci_appl)
• Justification ('justification') multi-line text

I want the user to populate the Business Unit field on the catalog item (business_unit) and upon using the MRVS, the first variable (business_unit_mrvs) be populated with the value chosen previously.

The reason for this is that i need to filter values for 'application_choice' to only display applications associated with the business unit (cmdb_ci_appl.business_unit) and i cannot seem to filter MRVS reference lists with a non MRVS variable...

[Brian Lancaster]

What patch level are you at in Madrid.  I have seen another post today that sounds similar that mentions being told to upgrade to Patch 5.

https://community.servicenow.com/community?id=community_question&sys_id=9b19bc91dba7bfc0414eeeb5ca96...

[john_duchock]

We are currently on patch 4a.

Looking thru the release notes, there doesn't seem to be anything about populating or filtering MRVS based on a catalog variable...  😞

[siva_]

Hello John,

Its not possible as of now to maintain a dependency between variables in cat item and the variables inside MRVS and vice versa.

There is no way as of now to copy or access  the variable which is  outside MRVS 

But if you have business unit inside MRVS, then y it cannot have the reference qualifier set for another two fields inside MRVS itself, you can have dependency inside the fields in MRVS.

 Mark this response as correct if that really helps

Thanks,

Siva

[john_duchock]

Version: Build tag: glide-madrid-12-18-2018__patch4a-07-09-2019

Aye, i do have the variable in the MRVS, but i dont want the user to have to populate it for each "add"...after all, the value will be the same.  I do have a method to filtering MRVS value2 based on the choice of MRVS value1 which works well...however, i need to pass the "global" value collected on the record producer to MRVS value1 so that MRVS value2 can be properly filtered...

I will read the release notes on P5 tonight and see if anything jumps out.