Telegrammliste
{BENUTZER} ({FUNKTION})
Telegrammliste
{sql}SELECT FIRST 250 RUFNAME,MELDUNG, CAST(ZEITSTEMPEL AS TIME) AS TZEIT FROM HISTORY where ZEITSTEMPEL > DATEADD(-12 hour to current_timestamp) ORDER BY ID DESC| {/sql}
%TZEIT% %RUFNAME% %MELDUNG%
 
Alarmierungen
{sql}SELECT RUFNAME,MELDUNG, CAST(ZEITSTEMPEL AS TIME) AS TZEIT FROM HISTORY where ZEITSTEMPEL > DATEADD(-24 hour to current_timestamp) AND RUFNAME='Alarmierung' ORDER BY ID DESC| {/sql}
%TZEIT% %RUFNAME% %MELDUNG%