Filter a reference qualifier

[SebastienC]

Dear,

I have the current reference qualifier:

javascript:"account="+current.variables.accountRF;

Where accountRF is a sys_id. It's working very well (even a bit slow, but that's not the issue currently).

I'd like to add a filter on this reference qualifier, to remove certains results (where the name does not contains CONTACT).

javascript:"account="+current.variables.accountRF+'^nameNOT LIKE'*CONTACT'';

but this does not work 😕  Even by removing the *.

Does anyone have a solution for this?

Many thanks in advance.

[Veer · Accepted solution]

Hello @SebastienC  Instead of adding code inline on the advanced condition, write a script include & glide the respective table & add all conditions within addQuery or addEncodedQuery, query the table & return the sysId. 

Call the script include in the advanced condition.

This works absolutely, 

Please mark this as Accepted solution / Helpful

[SebastienC]

Yes I'll test it like this... but i prefered to avoid a script include as my requirement is simple.

But if it's the only solution... will do it 🙂

[Vasantharajan N]

Please use the below syntax for reference qualifier

javascript:"account="+current.variables.accountRF+'^nameNOT LIKECONTACT';

javascript:"account="+current.variables.accountRF+"^nameNOT LIKECONTACT";

[SebastienC]

Many thanks for your proposition but something didn't work. Finally I succeed to script it.