Create a Reference Qualifier for a List Collector Variable that is a equivalent to : Attribute is one of (User Defined List of Attributes))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-11-2022 09:19 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-11-2022 09:30 AM
Hello,
You can try like below
in reference qualifier type in show related fields like below
And then select show related fields and then in the same field type sys_id like below
Then select operator as is one of put sys_id in "," comma seperated values like below
Try this it might work
Please mark my answer correct if it helps you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-11-2022 10:29 AM
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]');