You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello,
I'm trying to connect several table queries from different sources in Grafana, unfortunately without success.
Query 1(Influxdb) contains the measurement results with two foreign keys. Query 2(SQLite) contains primary key that points to FK1 and the description for FK1(Query 1).
Query 3(SQLite) contains primary key pointing to FK2 and the description for FK2(Query 1).
When I connect query 1 with query 2 via INNER JOIN and column GA it all works when query 1 has records.
Problem 1:
If query 1 has no records, then all records from query 2 are displayed.
It would be correct that no data records are displayed at all.
Problem 2:
When I join query 1 to query 2 using column GA and to query 3 using column PA and INNER JOIN, the second INNER JOIN is ignored.
What am I doing wrong?
Do you have a solution for problem 1 and problem 2?
Query 1
SELECT time, GA, PA, Val FROM /^$line$/ WHERE ("GA"::tag =~ /^$ga$/) AND ("PA"::tag =~ /^$pa$/) AND $timeFilter order by time desc limit 10
Query 2
Select GA, Name AS GA_TEXT From GA
Query 3
Select PA, Name AS PA_TEXT From PA
What did you expect to happen?
Problem 1:
It would be correct that no data records are displayed at all
Problem 2:
That INNER JOIN works
It would be correct that no data records are displayed at all
Did this work before?
no
How do we reproduce it?
see description above
Is the bug inside a dashboard panel?
No response
Environment (with versions)?
Grafana: Docker Version 11.0.0
OS: Debian
Browser: Google Chrome Version 124.0.6367.209
Grafana platform?
Docker
Datasource(s)?
Influx, SQLite
The text was updated successfully, but these errors were encountered:
Hello,
Thank you for your recommendation.
Yesterday I tried to install the version grafana/grafana-oss-dev:11.1.0-178727 in Portainer, unfortunately without success. I get the same error message with the other grafana dev-versions.
What happened?
Hello,
I'm trying to connect several table queries from different sources in Grafana, unfortunately without success.
Query 1(Influxdb) contains the measurement results with two foreign keys. Query 2(SQLite) contains primary key that points to FK1 and the description for FK1(Query 1).
Query 3(SQLite) contains primary key pointing to FK2 and the description for FK2(Query 1).
When I connect query 1 with query 2 via INNER JOIN and column GA it all works when query 1 has records.
Problem 1:
If query 1 has no records, then all records from query 2 are displayed.
It would be correct that no data records are displayed at all.
Problem 2:
When I join query 1 to query 2 using column GA and to query 3 using column PA and INNER JOIN, the second INNER JOIN is ignored.
What am I doing wrong?
Do you have a solution for problem 1 and problem 2?
Query 1
SELECT time, GA, PA, Val FROM /^$line$/ WHERE ("GA"::tag =~ /^$ga$/) AND ("PA"::tag =~ /^$pa$/) AND $timeFilter order by time desc limit 10
Query 2
Select GA, Name AS GA_TEXT From GA
Query 3
Select PA, Name AS PA_TEXT From PA
What did you expect to happen?
Problem 1:
It would be correct that no data records are displayed at all
Problem 2:
That INNER JOIN works
It would be correct that no data records are displayed at all
Did this work before?
no
How do we reproduce it?
see description above
Is the bug inside a dashboard panel?
No response
Environment (with versions)?
Grafana: Docker Version 11.0.0
OS: Debian
Browser: Google Chrome Version 124.0.6367.209
Grafana platform?
Docker
Datasource(s)?
Influx, SQLite
The text was updated successfully, but these errors were encountered: