Elasticsearch: Query variable with multiple fields

[4quarks]

Dear Grafana team,
I would like to know if it is possible to query a variable using multiple fields.
i.e. {"find": "terms", "field": "data.name", "field": "data.name_short", "size": 1000}
I would like to use the information from two fields in the same variable.
Thanks!

[torkelo]

How would you use this variable?

[4quarks]

It would be used in the same way as the normal variable. The only thing is that it would collect information from two different fields. Another possibility would be to combine two variables or have multiple queries:
i.e.
{"find": "terms", "field": "data.name"} + {"find": "terms", "field": "data.name_short"}

[Elfo404]

Combining 2 variables or having 2 queries for the same variable is not currently possible.

We need to check if this is achievable with a single Terms query (https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-terms-query.html#query-dsl-terms-lookup) and probably we'll need to update how the query is sent/parsed in the elasticsearch plugin

[IamShubhamGupto]

Hey @4quarks

Does the query {"find": "terms", "field": "data.name"} return any values? Im also running a terms query but I get None all the time