Populate String to Checkbox list

Hi TTN,

What is your data source type? are you pulling the data from SQL?

It  just a regular string concat them together with ; separation 

Hi,

I though you could use stored procedure as data source of the checkbox list to split the string for you and return it as list:

examples:

http://stackoverflow.com/questions/23089579/how-to-separate-split-string-with-comma-in-sql-server-stored-procedure

http://community.k2.com/t5/K2-blackpearl/Populate-drop-down-with-each-item-from-picker-control/m-p/86365#M26606

Thanks, Mustafa.

To get around, I did repopulate the listview with the orginal smartobject list, then I set the filter.

If I set filter Operator to "equal" and Value to CNPE then it work, it display one item for me.

Howerver if I set the fitler Operator to "contain" and value to "Activation;CNPE;Conflict of Interest;Contract/Budget;" then nothing happen.

The result I want is 4 checkboxlist display on the screen. Is there away to fitler anything like this.

Thanks

Hi,

If I understand correctly, you have those values already seperated but you want to display only 4 of them? if yes, then just modify your filter.

Go to the populate action and configure advanced condition in the filter tab, example:

If that doesn't help then you need to create stored procedure to retrieve the data you need.

Thanks, Mustafa for your help.

However, My list string is dymanic, it can be 1 item or 10 or 20 items and so on.

And also the list value can be different all the time when I popup the subview.

Is there a way I can filter by seperate by semicolon ";"

Thanks 

Hi,

Unfortunately it's not possible, the only way I could think of is stored procedure.

Thank again for your help.

I guess I have to build the smartobject list then store the data in it.

Sorry, I am new to K2. I am not sure what do you mean by "categories" control. What control is this?

Do you have any example which I can look at

Thanks.