[dashboard] how to use multiselect value in query

[totola147]

In dashboard we setup an input(multiselect) , and want to use the selection values in sql clause which like "select * from table where column in ( variables from multiselect ), but does not work .

how to use multiselect input value ? and what's the difference between multiselect and multicombo ?

[Subhajit97]

Hi @totola147, please have a look at our reference documentation. You can view all the supported input types with examples there.
Hope that helps, please let me know if you have any additional questions!

[totola147]

the document does not show how to use multiselect & multicombo as param in sql

[totola147]

i just get things done , to use multiselect input value , first ,multiselect input value is a string split by ',' so we get a string ;
second , use with () clause to convert string to array then convert array to multi row ; select unnest( string_to_array( $1 ,',' )) as item
third , use with clause defined before in where "select *from xxx where xxx in ( select item from [with_clause] ) "