I'm creating a dashboard which uses the usual KQL for most metric panels. I have a esql based Table also in the dashboard. When filtering on the dashboard level, I see that the esql based Table is empty. Is there any special way in which filtering needs to be implemented when using esql within a dashboard?
Version: 8.17.5
The filters are appended to the ES|QL query and given the fields exist in your source, it should work as any other visualization.
I added a ES|QL table to the Flights dataset and checked the filters from controls or search bar also affect the table as expected.
Maybe you can share more details about the query you are doing? There is the Inspect tool that will show you the exact query you are doing and the results retrieved, even allowing you to copy it to test on the Kibana Console.
This a screenshot of how the inspecting tool looks for my example where both the ES|QL query and the filter for the Carrier field are combined.
© 2020. All Rights Reserved - Elasticsearch
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.
