Query for Multiple Select Component

[matsoc]

Hi,

I have a problem with the multiple select component for select different months in a sql query.
The query is:

SELECT DISTINCT Month
FROM activity
WHERE Mese=(${param1})

This is a simple example to explain my problem, if I select one month in the multiple select component it work but obviously if I select more than 1 it doesn't work. How can I do to pass two or more month?

Thanks!
M

[johanhammink]

Your query is not correct. Use IN in the where statement when multiple values
SELECT DISTINCT Month
FROM activity
WHERE Mese IN (${param1})

[matsoc]

Your query is not correct. Use IN in the where statement when multiple values
SELECT DISTINCT Month
FROM activity
WHERE Mese IN (${param1})

Thank you, tomorrow I will try.

Is possible to list all the values of the multi select component horizontally? How?