Filter out choices in a Catalog Item variable

[Thomas G]

Hi,

I have a Catalog Item with a List Collector variable with a reference to the question_choice table and this Ref. Qual.:

javascript:'question=c6d947af1be38150640880f4464bcb85^inactive=false'; 

It is a List Collector because I need to be able to choose more than one choice for that particular Catalog Item. 

From another Catalog Item I need to look at the same choices but in that Catalog Item it should not be possible to select more than one choice, so I have created that as a Reference variable also as a reference to the question_choice table and with the same Ref. Qual. It works but the tricky part is that I have three choices that I need to filter out in this Catalog Item and I can not find a way to do that by changing the Ref. Qual. on the Reference variable. The three choices has '(security group)' in their name. I have tried many things, but no luck so far. I thought that this would work, but alas no:

javascript:'question=c6d947af1be38150640880f4464bcb85^inactive=false^nameNOT LIKE ".*\(security group\).*"';

Any ideas would be greatly appreciated 🙂

Best regards
Thomas

[Mark Manders · Accepted solution]

I just tested something by creating the query on the list and copy it. It came out like this: "question=d1b3f6fe9752cd1021983d1e6253afd2^inactive=false^textNOT LIKEAlpine GreenL"
Does the 'name' really contain ".*\(security group\).*", or do you just want to filter out the 'security group' string?

Then this should work: javascript:'question=c6d947af1be38150640880f4464bcb85^inactive=false^nameNOT LIKEsecurity group';

[Thomas G]

Thank you very much, Mark! 👍

Best regards
Thomas