maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_ro_fast_alert(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 idalert, relevantinfo, enabled, active, alert_type, idalertconf, alertdate, iddevice, creationdate, additionalinfo, latitude, longitude, odometer, location, speed, ackcomment, ackcommentuser, ackcommentdate FROM public.alert WHERE iddevice = $1 AND alertdate BETWEEN $2 AND $3 order by alertdate desc limit 1000;