Closed redturtlepower closed 2 years ago
Could you export your dashboard (including settings for variables) as a JSON file and attach it here?
In my example query I use it works fine (by selecting all of them individually and with the "all" option)
Maybe as a reference:
I have the following query running fine:
with data(time, temperature, city) AS (VALUES
(724125600, 10, 'London'), (724161600, 11, 'London'),
(724161600, 20, 'New York'), (724197600, 21, 'New York'),
(724125600, 25, 'Washington'), (724197600, 26, 'Washington')
) SELECT * from data
WHERE city in (${cities:singlequote})
order by time
With this being the query variable
SELECT * FROM (VALUES ('London'), ('New York'), ('Washington'))
Thanks for the example. This is no bug, the query was wrong on my side. I was not aware of the :singlequote
command. Also I had a =
instead of IN
in my query.
Describe the bug Using multi-value filters produces query that is not understood by SQLite and retunrs no results: Generated filter query is like
column="{value1, value2}"
but shouldn't it be likecolumn IN ("value1", "value2")
?To Reproduce Steps to reproduce the behavior:
Versions (please complete the following information):