Variable Name for Interval Select Input in Clickhouse Query

TLDR Romario asked for the variable name for interval select input. Ankit suggested using `{{.start_datetime}}` and `{{.end_datetime}}`.

Photo of Romario
Romario
Mon, 24 Apr 2023 17:36:26 UTC

Hello! What’s the variable name of the interval select input? How can I use this in a clickhouse query?

Photo of Romario
Romario
Mon, 24 Apr 2023 17:49:31 UTC

There’s also a panel time select but I can’t find any info in the docs

Photo of Ankit
Ankit
Mon, 24 Apr 2023 18:01:59 UTC

try `timestamp > {{.start_datetime}} and timestamp < {{.end_datetime}}` in you clickhouse query

Photo of Romario
Romario
Mon, 24 Apr 2023 18:04:37 UTC

it worked!

Photo of Romario
Romario
Mon, 24 Apr 2023 18:04:37 UTC

thanks