Hello
I have a issue, i have make a query from MySQL DB, and return a few value, and a timest, that are the timestamp, a char field, I recive the results from the qyery, BUT no lines in the chart. i can se there is plenty of row to make lines from... is there any issue with the 'timest' field from the DB?
Hi, Jonas. I deleted the "Perspective" tag from your question because this is a "Reporting" module problem and that is independent of Perspective.
No obvious problem. Perhaps the chart's timespan isn't matching the data's timespan?
Hello, thanks for the input, but isnot the charts timespan "auto" adjust to the input?
Did you manually scale the axes? I can't tell what your flow range is, but none of the values would plot in the 0-140 range shown on the left.
I connected the flow, to the right axis, that are 0-10000, and the other to the left axis 0-140,
it´s seems like the timespan, is not understand by the chart..
Strange thing this, no solution yet....
Might be a timezone issue. What timezones are the gateway, DB, and client in this case?
The timezone on the server is CET+1, Stockholm, I have a report thats run on another site, with the same timesetting on the server. and that report looking fine... this is a screenshot from the both GW
is the same formatting, and the project is both using the Gateway time setting.
if i run the query manual, i got the result.
Very strange
I see now, that the GW version on the working side, is 8.1.20, and the faulty is 8.1.23
You might want to get support involved. The cause is not immediately apparent. (Database?)
I would think so, but I don't know. You might want to get support involved. I cannot explain what you are encountering.
Hi..
Small updates on this issue.
After research, i see that the Timest filed in the MySQL db, is a char field, and not a DATETIME field,
i try to use the str_to_Date() function, but no success,
I try to export som day from the MySQL db, and import it to a SQL DB, with the DATETIME set on the timest field, and o got plot directly
i get back...
