Třídová akce

Popis:

Data prostředí za pracoviště nebo kapacitní jednotku a časový interval

Kód:

18

Tělo:

SELECT 
   IOT.SENSOR_ID, 
   IOTS.NAME, 
   IOT.SENSORQUANTITY, 
   IOT.NUMERICVALUE, 
   IOT.SHORTSTRINGVALUE, 
   IOT.DATETIMEVALUE$DATE, 
   BOOLEANVALUE,
   VALUEDATATYPE,
   RECORDEDAT$DATE
FROM  IOTDATA IOT
LEFT JOIN IOTSENSORS IOTS ON IOTS.ID = IOT.SENSOR_ID
WHERE 
  IOT.OBJECTCLASS = :ObjectClass 
  AND IOT.OBJECT_ID = :Workplace_ID
  AND IOT.SENSORQUANTITY = :SensorQuantity
  AND IOT.RECORDEDAT$DATE BETWEEN :DateFrom AND :DateTo

Generated by ABRA Software a.s. 27.10.2021 16:34:49