question Re: Help with record producer advanced reference qualifier in Developer forum

Help with record producer advanced reference qualifier

Joe Weisiger — Wed, 07 Sep 2022 20:56:23 GMT

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

Re: Help with record producer advanced reference qualifier

brianlan25 — Wed, 07 Sep 2022 21:15:12 GMT

What type of variable are you trying this on?

Re: Help with record producer advanced reference qualifier

Joe Weisiger — Wed, 07 Sep 2022 21:16:38 GMT

Contract model is a reference field on the record producer. I should note that the 1st part works by itself.

javascript:'vendor='+current.variables.vendor

Re: Help with record producer advanced reference qualifier

brianlan25 — Wed, 07 Sep 2022 21:20:55 GMT

Looks like you are hard coding contract_model so I don't thing you need current since your not pulling it from a variable or anything. So I think it should just be javascript:'vendor='+current.variables.vendor^contract_model="8881e836c3102000b858fd251eba8f28";

Re: Help with record producer advanced reference qualifier

Joe Weisiger — Wed, 07 Sep 2022 22:07:05 GMT

Thanks Brian. I tired this and the field still lists all contract models instead of just the hard coded one.

Re: Help with record producer advanced reference qualifier

Nick Parsons — Wed, 07 Sep 2022 23:10:47 GMT

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.

Re: Help with record producer advanced reference qualifier

brianlan25 — Fri, 09 Sep 2022 18:03:47 GMT

Good catch.

Re: Help with record producer advanced reference qualifier

MarjanA — Wed, 05 Mar 2025 18:50:26 GMT

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&colon; '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&colon; 'parent=' + current.variables.u_requested_by_lob_v2

Re: Help with record producer advanced reference qualifier

brianlan25 — Wed, 05 Mar 2025 19:39:10 GMT

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

Re: Help with record producer advanced reference qualifier

MarjanA — Wed, 05 Mar 2025 19:40:25 GMT

a list collector

Re: Help with record producer advanced reference qualifier

Nick Parsons — Wed, 05 Mar 2025 22:29:04 GMT

The operator should just be IN not IN=:

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