I'm running into an issue when using multiselect boxes.
For example, suppose my query is like that:
select *
from TABLE A
where A in ({{multiselect4.value}})
and B in ({{multiselect5.value}})
I will come across the error: Bind Variable:1 not set.
However, if I take away one condition (any condition), the query will run fine.
I am using Snowflake, and I've used all kinds of functions. They will all work on one condition only, not on two or more. Likewise, this error pops up when I'm using 'union all' to merge two queries using multiselectors.
Anybody has any idea what went wrong? This looks increasingly like a bug.
When you're hovering over the ({{multiselect4.value}}) or ({{multiselect5.value}}), what do you see? Are they green or red? May you share a screenshot of this query of yours? If you're uncomfortable doing that please chime into our chat support and we can help you there as well.
Also, please feel free to share screenshots of your multi-select components themselves being used here in your query.
Got it! The bug should be fixed on the non-self hosted version of Retool. Here's a similar query with dummy data that's working in my non-self hosted instance:
Does each of your select statements work on it's own i.e querying SELECT * FROM TABLE1 WHERE X={{blah}} and then separately querying SELECT * from TABLE2 WHERE Y={{blah}} ?
Can you also confirm that your resource does not have this setting checked on in the resource setup page?