Zucker and multi-select result

[j.lagos]

In the query result of a Zucker report, there are values from a multi-select field like M^,^S...

Is there a way to translate them to the coresponding labels?

Thanks

[sugarcane]

Hello John,

In the SQL query SELECT statement, you use something like this for your multiselect field:

replace(d.multiselect_c,"^,^",CHAR(13))

so that you SQL statement looks something like this:

SELECT c.first_name, replace(d.multiselect_c,"^,^",CHAR(13)) As New
FROM
contacts c left join contacts_cstm d on c.id=d.id_c

The above will create a carriage return between the different values so that valuea^,^valueb will appear as:

valuea
valueb

Or you could use something like this to separate the value by a semicolon:

replace(d.multiselect_c,"^,^", "; ")

so that your values will appear as
valuea; valueb