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
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
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