Hello Ignition Community,
I'm encountering an issue with timezone conversion in a Perspective table. The table is bound to a named query, and the result includes
end_time columns in UTC. My Perspective project is configured with the timezone ID set to "America/Lima," and all other components correctly convert timestamps to this timezone.
However, this specific table seems to be offsetting timestamps by -2 instead of the expected -5 (GMT-5). Other components like journal tables, alarms, and charts are displaying the correct timezone conversion.
In the Perspective project settings, the timezone ID is correctly set to "Client TimeZone."
I'm seeking advice on how to troubleshoot and resolve this issue specifically for the Perspective table. Has anyone encountered a similar problem or can provide insights into why this might be happening?