Spaces:

zaheer140
/

liveChatBotBackend

Runtime error

liveChatBotBackend / agents /live /scratch /debug_sql.txt

Upload 447 files

1129495 verified 5 months ago

479 Bytes

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

	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