Supervisor - Medienereignisse

AcdEvents (CACHE)

Query

DataCache_AcdGroups_TodaysEventData.sql

WHERE ( AcdGroupsID = $ACDGROUPSID ) 
AND
( dtLastModified >= DATETIME( DATE( 'now', 'localtime', '+$STATISTICS_FROM_HOUR hour', '+$STATISTICS_FROM_MINUTE minute' ) ) );

Keine

Berechnung:

IFNULL( SUM( CASE
 WHEN ( AcdEventTypesID = $MEDIA_TYPE ) 
 AND 
 ( AcdEventStatusID IN ( 1, 2, 10 ) ) THEN 1
 ELSE 0
 END
 ), 0 ) AS $MEDIA_TYPEDistributed,

Anzeige:

$MEDIA_TYPEDistributed

Berechnung:

IFNULL( SUM( CASE
 WHEN ( AcdEventTypesID = $MEDIA_TYPE ) 
 AND 
 ( AcdEventStatusID = 20 ) THEN 1
 ELSE 0
 END
 ), 0 ) AS $MEDIA_TYPENewAgent,

Anzeige:

$MEDIA_TYPENewAgent

Berechnung:

IFNULL( SUM( CASE
 WHEN ( AcdEventTypesID = $MEDIA_TYPE ) 
 AND 
 ( AcdEventStatusID = 30 ) THEN 1
 ELSE 0
 END
 ), 0 ) AS $MEDIA_TYPESeenAgent,

Anzeige:

$MEDIA_TYPESeenAgent

Berechnung:

IFNULL( SUM( CASE
 WHEN ( AcdEventTypesID = $MEDIA_TYPE ) 
 AND 
 ( AcdEventStatusID = 100 ) THEN 1
 ELSE 0
 END
 ), 0 ) AS $MEDIA_TYPEError,

Anzeige:

$MEDIA_TYPEError

Berechnung:

IFNULL( SUM( CASE
 WHEN ( AcdEventTypesID = $MEDIA_TYPE ) 
 AND 
 ( AcdEventStatusID = 99 ) THEN 1
 ELSE 0
 END
 ), 0 ) AS $MEDIA_TYPEDone,

Anzeige:

$MEDIA_TYPEDone

Anzeige:

#{todaysMediaDataBean.sumOfColumn('$MEDIA_TYPEDistributed')}

Die Summe der Spalte "Verteilen".

Anzeige:

#{todaysMediaDataBean.sumOfColumn('$MEDIA_TYPENewAgent')}

Die Summe der Spalte "Neu Agent".

Anzeige:

#{todaysMediaDataBean.sumOfColumn('$MEDIA_TYPESeenAgent')}

Anzeige:

#{todaysMediaDataBean.sumOfColumn('$MEDIA_TYPEError')}

Anzeige:

#{todaysMediaDataBean.sumOfColumn('$MEDIA_TYPEDone')}