Calling All from variable

Grafana Dashboards
, ,
1

Hi,

I have a dashboard variable that produces lots of results from an SQL query. I want to use all of these results as a list within a Elasticsearch query. If I reference the variable I get the first result. I cannot use GROUP_CONCAT in SQL as the results set is larger than 1024

I have tried things like ${__all:myVariable} but just cannot seem to get all of the results.

Would anyone have any suggestions

TIA

2

Hi @cbillett83,

Welcome to the :grafana: community support forums !!

We are excited that you joined our OSS community. Please read about some of the FAQs in the community :slight_smile:

Can you please share a screenshot or a small screencast/gif file so that we can see how you are?

For e.g. How you are creating the Dashboard variables from that SQL query (not sure which Datasource type it is e.g. MySQL, MSSQL, etc).

Then explain how you using this variable in the Elasticsearch query?

Thanks