Query Query-Result-Cache with parameters


#1

The feature to query existing queries with parametes is described here:

How I understand this, the feature is already implemented. (?)

However trying to query an existing query like this:

SELECT * FROM query_250('{ "mindate":"2018-08-30", "maxdate": "2018-11-30" }')
is leading to the error:

Error running query: Failed loading results for query id 250.

I am using Redash 5.0.2+b5485 and Query Results Cache as data source.

The query_250 has only the two parameters mindate and maxdate used like that:

  AND "sessionStart" >= TIMESTAMP '{{mindate}}'
  AND "sessionStart" < DATE_ADD('hour', 24, CAST('{{ maxdate }}' AS TIMESTAMP))