Using data from MultiSelect in SQL

[mpage]

I have read a number of the other topics on this, but can't seem to get this query to work when using {{multiselect.value}}. I have also used a transformer to put the info into a string. The query works when I type in the info directly. Any ideas? Is there something I need to account for when using this in SQL? SimTeams.value is the multi select.

This code works

I have tried joining the data from the multiselect value

This is the transformer code I have used.

Transformer in the code.

[ScottR]

Welcome to the forum!
The multi-select value should already be an array of what was selected....

But that being said in your query try using er.team_code = ANY({{multiselect value here}}) instead of IN

[mpage]

@ScottR

er.team_code = ANY({{multiselect value here}})

That worked, Thank you! I knew there was something simple I was missing...