Acessing variables in Advanced Reference Qualifier from a variable set

[Javi2]

I have a Record Producer with this structure.

Record Producer{

         Variable 1

         Variable Set {

                  Variable 2

         }

}

Variable 1 is inside the record producer but Variable 2 is in a variable set. I want to use variable 1 value to filter Variable 2 using an advanced  reference qualifier but 'current.variables' refers to the variables in the variable set so I can't access variable 1.

Is there any way to achieve this?

Edit: This is a multi-row variable set.

[Manolis Sgouros]

Hello Stefan,

I tested your solution and just wanted to let you know that this wont work on Portal. It works fine in normal UI but wont work on Service Portal.

As a work around i do the following:

1. Create an onChange client script for the variables.company variable and store the value in a "parent.companyID" value.

function onChange(control, oldValue, newValue, isLoading) {
  if (isLoading || newValue == '') {
    return;
  }
  parent.parentCompanyID = newValue;
}

2. Create an onLoad client script in the Multi Row variable and do something like

 function onLoad() {
  
  //Set company ID to field
  g_form.setValue('companyid', parent.parentCompanyID);
}

PS: There is also the following: g_service_catalog.parent.getValue('company')

The above works in Portal and in normal UI.

Link

Cheers,
Manolis.

[Stefan42]

Hello Manolis,

I only had this requirement for the normal UI so i did not test it on the portal. Maybe i had to mention this in my post. Do i see a little typo in your client script at step 1? 

"parent.parentCompanyID = newValue;" should be: "parent.CompanyID = newValue;"

Thank you for testing this and creating a work around!

Regards,

Stefan

[Manolis Sgouros]

You are right, just corrected the typo.

The first part is a "dirty workaround". I think the best solution would be the function from SNOW:

g_service_catalog.parent.getValue('company')

I also linked the related doc.

Cheers,
Manolis.