maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_ro_get_event_temperature(integer, timestamp with time zone, timestamp with time zone)
Parameters
Name
Type
Mode
iddevice
integer
IN
startdate
timestamp with time zone
IN
enddate
timestamp with time zone
IN
Definition
SELECT idevent,iddevice,senddate,temperatures,latitude,longitude,location,idunit, ignition_status,event_code FROM event_temperature WHERE iddevice = $1 AND senddate BETWEEN $2 AND $3 ORDER BY senddate ASC;