ladder99 icon indicating copy to clipboard operation
ladder99 copied to clipboard

Add more SQL examples how to query database

Open MRIIOT opened this issue 3 years ago • 2 comments

example:

SELECT
  substring(path,'$device/(.*)') as attribute,
  time,
  value,
  lower(units) as units
FROM history_all
WHERE
  path IN ('$device/Availability', '$device/LoadCondition', '$device/Message', '$device/FunctionalMode',
  '$device/SystemCondition', '$device/Controller/EmergencyStop', '$device/Axes/Rotary[C]/RotaryMode')

  and $__timeFilter("time")
order by time desc
limit 200

MRIIOT avatar Dec 17 '22 00:12 MRIIOT

@bburns Proposed tasks have no assignees.

MRIIOT avatar Dec 17 '22 19:12 MRIIOT

@MRIIOT, we might want to configure GitHub Action to auto-remove all assignees when an issue is in proposed in the project.

tukusejssirs avatar Dec 17 '22 19:12 tukusejssirs