Filter SQL data while using multiSelect Combobox

[Muthu_chithira]

Hi All,

Based on selection of combobox, have to filter data. For that i wrote sql query as:

             SELECT col1  FROM table where col1 in ([[CheckInfo]])

        Input :- CheckInfo='value1','value2'

But filter is not happening

But if i give Input as :- CheckInfo='value1' 

It fetching data.

How to give input for multivalues

Thanks 

[Constantine · Accepted solution]

Hello @Muthu_chithira,

Depending on the underlying RDBMS, you might be able to split the string in SQL, e.g. STRING_SPLIT for T-SQL.

Regards,
Constantine