Display Second Column as the value in a muti selection list collector
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-14-2023 11:22 AM - edited ‎11-14-2023 11:26 AM
I am using a list collector that allows multiple selections in a drop-down, there are two columns CNB1 and CNB2. Those are displayed in the drop-down as a selection but when I select an item in that drop-down the first column CNB1 is selected as the value of the drop-down but I want the second column CNB2 to be selected as the value.
Conditions for the display columns will be first CNB1 and CNB2. when selecting it should display CNB2 as the value.
Note: Is there anything that I can do to achieve a possible solution for that problem? Are there any variable attributes that can help, but my understandings says it can't be done using a variable attributes for that catalog item variable [List Collector]
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-14-2023 01:41 PM
The value of a list collector will always be a comma-separated list of sys_ids for the records selected. The column displayed when you make selections is the column on the list table definition that is set to true for the Display field. Note that changing this will change it for the table system-wide, so any place the form, reference, or list/list collector are used.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-15-2023 07:48 AM
Correct, values are separated by a comma. But when I select a value in the list, it displays Column=true as the display value in that list collector, rather I want another column besides the column=true in that list to be displayed as the value of the record. I can't change the column=true field for that as there is another list collector that needs the first column to be the display value. I hope you understand me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-15-2023 09:16 AM
I understand what you're saying. There is not a way to display a column other than the list table display column. One alternative is to have a nearby multi-line text variable read-only that you populate with the values. You would use an onChange Catalog Client Script that calls a Script Include via GlideAjax to lookup and create an array of field values for the list of sys_ids. This list would be re-built with each change of the list collector variable, so if selections are added or removed the other variable's value would always be in sync.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-15-2023 02:12 PM
After doing some research, I've come to the conclusion that it is not possible to do so, So will try to have an alternative solution to that besides someone came up with a more accurate one, Thanks for such information.