I am developing a report in Canvas currently and several elements use the same field within their esql queries. As it is intended that this workpad would be cloned it would be really useful to use a variable in the query Currently I have essql query="SELECT HISTOGRAM(isotimestamp, INTERVAL 1 DA…

Hi @IGB042 You'll have to use string concatenation to get the variable into the query. So it would look something like essql query={ string "select * from MyIndex where account_id='" {var name="AcctID"} "'" }

Discuss the Elastic Stack

Using workpad variables in esql queries

Elastic Stack Kibana

IGB042 (Ian) September 22, 2021, 10:51pm 3

Awesome Corey, did find I can drop the name= from the expression.

This is going to simplify the report creation process so much.

Topic		Replies	Views
Passing essql statements in Workpad Variables Kibana canvas	2	593	October 29, 2021
How to use variable in canvas Kibana canvas	2	1480	June 6, 2022
Canvas - Variable in essql Kibana canvas	1	1156	February 16, 2022
Using essql query results a second query against another index Kibana elastic-stack-sql , canvas	3	501	April 7, 2023
Dashboard variables set dynamically from a query Kibana	14	465	September 17, 2025

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Using workpad variables in esql queries

Related topics