Error: Bind variable :1 not set

How do I?
#1

Hi,

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.

#2

Any help, pls?

#3

Hi @rile06 I'll try to get some help from the team on this for you, and confirm whether or not it is a bug. Hang tight, thanks!

#4

Hi there @rile06

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.

Best

Pawan