maya.public

Parameters

Name	Type	Mode
_iddevice	integer	IN
_startdate	timestamp with time zone	IN
_enddate	timestamp with time zone	IN

Definition

SELECT m.idmessage, 
       m.iddevice, 
       m.enabled, 
       m.messagetype, 
       m.senddate, 
       m.conversation_id, 
       m.idevent, 
       m.longitude, 
       m.latitude, 
       m.messagestatus, 
       m.idmayauser, 
       CASE 
       WHEN m.messagetype = 1 then m.device_aknowledge
       WHEN m.messagetype = 3 then mc.macronumber || '-' || mc.description || ' : ' || m.device_aknowledge 
       END device_aknowledge, 
       m.devmessageid, 
       m.location,
       CASE 
       WHEN m.messagetype = 1 then p.body
       WHEN m.messagetype = 3 then mc.macronumber || '-' || mc.description || ' : ' || m.device_aknowledge 
       END body, 
       m.viewed, 
       m.receiveddate, 
       m.creationdate, 
       p.iddriver, 
       CASE 
       WHEN m.messagetype = 1 THEN p.whoissender
       WHEN m.messagetype = 3 THEN ma.whoissender
       END whoissender
FROM   PUBLIC.message m 
       LEFT JOIN PUBLIC.plainmsg p 
         ON p.idmessage = m.idmessage
        left join macro ma ON ma.idmessage = m.idmessage left join macroconf mc ON mc.idmacroconf = ma.idmacroconf
WHERE  iddevice = $1 
       AND m.messagetype IN (1,3)
       AND m.senddate BETWEEN $2 AND $3;

ot_ro_fast_plainmsg_v2(integer, timestamp with time zone, timestamp with time zone)

Parameters

Definition