Create a Reference Qualifier for a List Collector Variable that is a equivalent to : Attribute is one of (User Defined List of Attributes))

alantpham
Kilo Contributor

I have six variables that are all list collectors that references the same list table.

Each record in this list is mainly distinguished by the ID assigned to them (u_id). For each variable, I want to set a reference qualifier to only show records based on certain IDs I want shown for that particular variable.

Basic Context

List Table: 55 Records

Variable A: Show 11 Specific Records, Variable B: Show 5 Specific Records, Variable C: Show 8 Specific Records

Etc.

What would be the reference qualifier for a list collector equivalent of: Id is one of -> List of Ids Chosen by Me

2 REPLIES 2

Mohith Devatte
Tera Sage
Tera Sage

Hello,

You can try like below 

in reference qualifier type in show related fields like below

find_real_file.png

And then select show related fields and then in the same field type sys_id like below

find_real_file.png

Then select operator as is one of put sys_id in "," comma seperated values like  below

find_real_file.png

Try this it might work 

Please mark my answer correct if it helps you

 

ryan_pope
Mega Guru

I believe list collector variables don't provide the nice no-code ref qualifier condition builder, so you'd have to code it. You should be able to do something along the lines of this though:

javascript: 'u_idINu_id1,u_id2,u_id3';

And for the sake of ease of updates, I would probably store all of those IDs in a system property, which would update that reference qualifier to look like this:

javascript: 'u_idIN' + gs.getProperty('[insert property name here and remove the brackets]');