Supervisor - Medienereignisse

AcdEvents

(CACHE)

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

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

Anzeige:

$MEDIA_TYPEError

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')}

Anzeige:

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

Anzeige:

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

Anzeige:

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

Anzeige:

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