Help with record producer advanced reference qualifier

[Joe Weisiger]

Hello,

I have a record producer with a reference variable that requires an advanced reference qualifier. 

It is not working and looking for some help with the code.

javascript:'vendor='+current.variables.vendor^current.contract_model="8881e836c3102000b858fd251eba8f28";

Any help is appreciated.

Joe

[Nick Parsons · Accepted solution]

Looks like your quotes are in the wrong positions, try this instead:

javascript: 'vendor=' + current.variables.vendor + '^contract_model=8881e836c3102000b858fd251eba8f28';

I'm guessing contract_model is a field in the table that you're reference qualifier is being used to query.

[Brian Lancaster]

Good catch.

[MarjanA]

Hi how can I make this so that the variable Im getting the value from is a list collector and can have multiple values. Ive tried: javascript: 'parentIN=' + current.variables.u_requested_by_lob_v2 but it says "no matches found".

It works when there is only 1 entry with this: javascript: 'parent=' + current.variables.u_requested_by_lob_v2 

[Brian Lancaster]

What type of field are you putting the reference qualifier on?

[MarjanA]

a list collector