Query works in Explore but returns empty when used as a variable

[mirawara]

Hi,

I’m experiencing an issue where a query works correctly in Explore, but when I try to use the same query as a variable, it returns empty results.

Here’s the query:

[ { "$group": { "_id": "$stabilimento" } }, { "$project": { "_id": 0, "value": "$_id" } }, { "$sort": { "value": 1 } } ]

• In Explore, it returns the expected list of values.
• In Variables, it shows nothing.

I was expecting the variable to populate with the same results as Explore.

Is this a bug or am I missing something in how queries should be structured for variables?

Thanks!

[haohanyang]

Did you define any special variable in dashboard?. You can check the actual query in the Query Inspector in the panel editor

[mirawara]

Hi @haohanyang , thanks for the reply.

Just to clarify, I’m not using this query in a panel. I’m defining it directly as a variable in the dashboard settings.
And this is the only variable I have in the dashboard.

In Dashboards -> Settings -> Variables.

[mirawara]

@haohanyang
I may have found the bug: if the variable is named the same as the field in the MongoDB document (in this case, "stabilimento"), it doesn’t seem to work. Otherwise, it does