Filter SQL data while using multiSelect Combobox

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

Best answer by Constantine

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

Answer

18-Opal

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

Sign up