Help with record producer advanced reference qualifier

Joe Weisiger · ‎09-07-2022

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 · ‎09-07-2022

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.

Nick Parsons · ‎03-05-2025

The operator should just be IN not IN=:

javascript&colon; 'parentIN' + current.variables.u_requested_by_lob_v2;