Skip to Content Skip to Menu

Display Each Result of Multiple SelectBox In CB List Per Line and Not Comma Separated

8 years 8 months ago #278026 by kennysteve
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.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum