Open
Description
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