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
Highlighted
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
Highlighted

Re: Filter SQL data while using multiSelect Combobox

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
Highlighted

Re: Filter SQL data while using multiSelect Combobox

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

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!