question Re: How to get active user records populated in catalog item through reference qualifier in Developer forum

How to get active user records populated in catalog item through reference qualifier

Rini1 — Tue, 22 Oct 2024 17:22:51 GMT

Hi all,

I could find many articles in the community related to reference qualifiers and I have updated ref qualifier for one of my catalog items but still system populating inactive records not sure why. Attached screenshot for reference. Any guidance would be much appreciated.

Thanks

Rini

Re: How to get active user records populated in catalog item through reference qualifier

Brad Bowman — Tue, 22 Oct 2024 17:36:17 GMT

Use && between the conditions for AND, so yours would be - after the javascript colon

'active=true&&company=' + current.variables.company;

Re: How to get active user records populated in catalog item through reference qualifier

Anand Kumar P — Tue, 22 Oct 2024 18:12:24 GMT

Hi @Rini1 ,

You are using incorrect syntax by placing a comma between the active and company fields.

Incorrect:

'active=true,company=' + current.variables.company;

Correct Approach:

'active=true^company=' + current.variables.company;

Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand

Re: How to get active user records populated in catalog item through reference qualifier

Brad Bowman — Tue, 22 Oct 2024 18:32:28 GMT

Yeah, brain fog - that answer is rubbish. Use ^ not && in this case for an encoded query AND.