agents/live/scratch/debug_sql.txt

SELECT
  a.name AS asset_name,
  ad.timestamp + INTERVAL '3 hours' AS local_time,
  (ad.value::jsonb - 'Timestamp' - 'timestamp') AS sensor_data
FROM openremote.asset a
JOIN openremote.asset_datapoint ad
  ON a.id = ad.entity_id
WHERE a.id = (
  SELECT id
  FROM openremote.asset
  WHERE REPLACE(LOWER(name), ' ', '') = REPLACE(LOWER('ColdRoom1'), ' ', '')
  ORDER BY version DESC
  LIMIT 1
)
AND ad.attribute_name ILIKE 'data'
ORDER BY ad.timestamp DESC
LIMIT 10