cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Filter SQL data while using multiSelect Combobox

SOLVED
Muthu_chithira
5-Regular Member

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 

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

1 REPLY 1

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

View solution in original post

Announcements