The 'IN' condition in query builder doesn't seem to work for me... help appreciated

Hi,

I’ll keep it quick.

I’m just playing around still but trying to return a query using the IN condition and it will only work when 1 value is in there…the moment i put more than 1 value it returns nothing.

With the below screenshot, i am using a condition on week numbers in a year. If i put in 36 as an example it will work fine, returning only corresponding data for week 36. Same if i put in 37. But if i have both 36 and 37 (or any other combination) it returns NO data.

As far as i can tell using w3Schools, the syntax is correct and SHOULD work.

Any ideas on what i’m doing wrong?

Hello,
The IN condition expects an array and not a comma separated list. You need to add:

{{"36,37".split(",")}}

Ok that makes sense…I was just testing with numbers to make it easy before building some get filters. Turns out I should have just used the array.

I will test this soon but am sure that will fix it. Thanks again @Teodor

1 Like