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]

Hi @Peter Williams ,

Can you change the advanced reference qualifier to below. I think there is a syntax issue

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

[Peter Williams]

ok so now i am getting no records found

[Manmohan K]

@Peter Williams ,

Try with a combination of office and department you know which will return records in GL codes table

[Peter Williams]

yeah i did  i created a records specifically for Department and Office and results are the same. No records found