I have a list with a column whose values are supplied by a multiple selectbox choice(s). At first I had issues with the correct advance filter query to use but a thorough search on this forum revealed some awesome answers earlier provided by
krileon
and
nant
which guided me and now I have the list having the correct output. Below is the query I used:
(`cb_field` LIKE '%value1%') OR (`cb_field` LIKE '%value2%') OR (`cb_field` LIKE '%value3%') OR (`cb_field` LIKE '%value4%') OR (`cb_field` LIKE '%value5%') OR (`cb_field` LIKE '%value6%') OR (`cb_field` LIKE '%value7%') OR (`cb_field` LIKE '%value8%')
The problem I now have is that the selected values are displaying as comma separated in the column e.g.
Value2, Value4, Value7
Could someone please guide me on what to do to have them displayed per line e.g.
Value2
Value3
Value4
Thanks in advance.
