Variables: Query returns no results

fr-ser / grafana-sqlite-datasource

Grafana Plugin to enable SQLite as a Datasource

Apache License 2.0

126 stars 17 forks source link

Variables: Query returns no results #118

Closed sensej-j closed 11 months ago

sensej-j commented 11 months ago

Hi Sergej, this Variable-Query returns no results.

SELECT Raum FROM tws_config_new where [Typ] = 1 OR SELECT Raum FROM tws_config_new where Typ = 1 Everything runs successfully in DB Browser. When I click "run query" nothing happens.

What could that be?

That is how it goes, without "WHERE" SELECT Raum FROM tws_config_new;

OS: Debian Stretch (9.13)
Run via docker: yes
Browser: chrome
Grafana Version: 10.0.3
Grafana Container: grafana:10.0.3-ubuntu
SQLite Plugin Version: 3.3.2

fr-ser commented 11 months ago

Can you provide a test dataset?

sensej-j commented 11 months ago

Hello Sergei, I checked everything again yesterday. Sorry, that was my mistake. Everything works.