Populate a checkbox list from array stored in db

[Ricardo Saez Garza]

Hi I have a DB and one of the colum is defined as an array. My Rest service has all the values to represent the info in a collapsable set, and display correctly all Items. I embebed a checkbox control, where I need to show the options of the item, that are stored in the colum as an array.

How can I tell to this control that it have to take the array, and populate all the items of the array as options and not as string

This is what I want to do it
+Item 1
+Item 2
x option 1
x option 2
x option 3
But I have

+Item1
+Item2
x Option1, Option 2, Option 3 (The array is considered as string)

Thank you

[Kateryna Grynko]

Hi Ricardo,

To get the query results you would need to specify that the field is an array. Then the mapping opens response element as an array and will be able to map it to the Checkboxes list

[Ricardo Saez Garza]

Hi, I follow your instruction and I linked the field Options, which is defined like an array, and It works. It has generated 3 elements but I can't map the value and the text of the checkbox. All the items showed has the same label Item1 (three times). How can I update the label and the value? Thank you

[Maryna Brodina]

Hi, could you post your mapping screenshot?