search

fr-ser / grafana-sqlite-datasource

Grafana Plugin to enable SQLite as a Datasource
Apache License 2.0
124 stars 17 forks source link

Variable query not returning any values #42

Closed grifmang closed 3 years ago

grifmang commented 3 years ago

I'm trying to create a variable from a query to my SQLite database and I can't figure out why it doesn't return anything.

My query is simple,, and it works if used as a graph. Any ideas?

variables
fr-ser commented 3 years ago

There was a bugfix for something like this here: https://github.com/fr-ser/grafana-sqlite-datasource/blob/master/CHANGELOG.md#102

Can you please fill out the issue template, which includes the Grafana Version and SQLite plugin version?

grifmang commented 3 years ago

Sorry about that.

Describe the bug Variable query not returning any values.

To Reproduce Steps to reproduce the behavior:

  1. Go to Dashboard Settings -> Variables -> Choose Query -> Enter 'SELECT * from "table"'
  2. Click anywhere to load values
  3. Scroll down to values
  4. See error (No error. No values being returned)

Screenshots See OP

Versions (please complete the following information):

Additional context I'm now noticing that this was fixed in the newest version per your reply. I'll try and update.

grifmang commented 3 years ago

Seems to be working as expected now on version 1.2.1

My apologies.