Query variable error

I try to make Query variable at grafana v. 8.0.2, and 8.0.4 very simple

select CAST(ex_name as TEXT) q1 from history_model3 group by ex_name;

but every time get error “Validation: Cannot read property fields of undefined. Templating: Error updating options Cannot read property fields of undefined”

Select return 4 values

AMEX
MOEX
NASDAQ
NYSE

that’s all, I’ve made CAST? but without any results

I’ve using data source Sqlite DB plugin
I don’t understand what the reason of this error

At snapshot another request with the same error

um, did I read it wrong or
in your picture, you are selecting ‘date_rw’ → this give you error
and in your text, you are selecting ‘ex_name’ → ???

can you show me (in picture) what your table structure like
and the values in it
something like
select * from history_model3;

this is a sample from Mysql
*hope it is not too different

As I told the same error I’m getting at any sql requests I can’t make any query variable? I think it’s a bug of sqlite plugin


sorry cant help
I havent used sqlite
tried asking you for table structure (field name / values) → which we might work it from there
but if you said it is a bug, then we stop trying

I get the same, with sqlite as well.
It was reported to the sqlite plugin issue #46.
Plugin does not support version 8.x yet.

The issue is fixed with the release v2.0.2

It can take a while until Grafana releases this version on their webpage but the fix can already be used by using alternate installation instructions

This topic was automatically closed after 365 days. New replies are no longer allowed.