Page History

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

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