Matching multiselect with varchar array

Queries and Resources
1

hi,

I have a table that has an array object. I am trying to use a multi select filter to filter for all rows that have at list one of the matching values.

SELECT * FROM table WHERE {{expertisefilter.value}} <@ expertise::text[]

I'd thought that both sides will have an array values of text components but it seems that this is not the case. The original expertise column has a varchar array.

Any advice?

2

Hey @snowman! Can you share what db type (postgres, mysql, etc) you are using? We have a great post here that helps explain some of the different syntaxes required when using arrays in SQL in Retool. The final solution here is likely dependent on the db type.