Hello.
Im having problems when using some data from my postgres database.
Im unable to print that column in grafana even if i cast conver to varchar de data, i only see “No points available”. Any suggestions?
Thanks in advance
in query editor you can view genereated SQL can you look at that and test that manually ?
If i test it manually it works flawlessly, also, im getting this error:
If i execute the query manually at postgres i get no problem:
Also, i cast converted the “VALUE”::VARCHAR(5) which removes the error, but shows me no data.
You need to select 3 columns for Grafana: time, metric (=metric name), value (=metric value).
At the moment you are selecting only 2 + metric name is a metric value in your case.
I ended up working it around like this:
SELECT
$__time(“DATETIME”),
“VALUE” as in
FROM “STORAGE”
WHERE(
$__timeFilter(“DATETIME”)
AND “RELATIVE_ID” = 47) AND “VALUE” != ‘NaN’
ORDER BY 1
Turns out, there were a few NaN values inside the database…
Thanks everyone for your support!