Reference Qualifiers for a variable field

[Peter Williams]

Good Day everyone,

i am trying to make a Reference Qualifiers for a refence field on a table.

so far i have this

javascript: 'u_office='+current.variables.office_office+'^u_department='+current.variables.department_office; 

with the Variable attributes:

ref_qual_elements=office_office;department_office

what i need to do is add in if the record i am getting from the table is Active and is a Vendor invoice

u_active=true^u_vendor_invoices=true

the final output is 

Ref Qul:

javascript: 'u_office='+current.variables.office_office+'^u_department='+current.variables.department_office^u_active=true^u_vendor_invoices=true;

Variable attribute

ref_qual_elements=office_office;department_office

However when i use that, it brings in all records to the reference variable and not filtered as needed

any suggestions where i went wrong?

[Maik Skoddow · Accepted solution]

Hi @Peter Williams 

whenever you get all results this is an indicator for something broken. And I think I see the problem as I miss some characters (in red):

javascript: 'u_office='+current.variables.office_office+'^u_department='+current.variables.department_office+'^u_active=true^u_vendor_invoices=true';

Maik

[Maik Skoddow · Accepted solution]

Hi @Peter Williams 

whenever you get all results this is an indicator for something broken. And I think I see the problem as I miss some characters (in red):

javascript: 'u_office='+current.variables.office_office+'^u_department='+current.variables.department_office+'^u_active=true^u_vendor_invoices=true';

Maik

[Manoj89]

Hi Williams,

You are missing single quotations in your encoded query

Try: javascript: 'u_office='+current.variables.office_office+'^u_department='+current.variables.department_office +'^u_active=true^u_vendor_invoices=true';

[Sandeep Rajput · Accepted solution]

@Peter Williams You are missing the quotes in '^u_active=true^u_vendor_invoices=true';

Here is how the reference qualifier should look.