Using Reference Qual and Variable attributes in an MRV from Catalog item variables

[Peter Williams]

Good day,

i have two catalog item variables called office and department. These are reference items going to the cmn_location and cmn_department tables

I have an MRV that is linking to a custom table call GL codes. The columns for office and department is also link to the cmn_location and cmn_department tables.

the variables on the gl table is called u_office and u_department

When the user select their office and department i want the GL codes to be filter base on those option

i have this so far got the GL code reference in the MRV

Reference Qual:

javascript: 'u_office='+current.variables.office'^u_department='+current.variables.department

variable attribute:

ref_qual_elements=office^department

the GL codes are coming back with everything listed in it

[Manmohan K]

@Peter Williams ,

make ref_qual_elements=office;department

[Peter Williams]

same deal no records found

[Manmohan K]

@Peter Williams ,

You can remove the entire ref_qual_elements and try again. 

If it still does not work , then reverify the backend names of variables you are using in advanced reference qualifier because there might be a typo in there

I recreated the scenario and it worked in my PDI with the advanced reference qualifier