Changes between Version 19 and Version 20 of DatabaseBasedAnalysis/Tables

Timestamp:

09/03/18 18:45:24 (7 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis/Tables

@@ -78 +78 @@
 ||=Failed       =||  > 2000            ||  > 2000           ||   NOT NULL          || Processing failed                                      ||
 ||=Blocked      =||  < 2000            ||  < 2000           ||    [NULL]           || Processing is not supposed to run for this index       ||
+
+A corresponding query could look like the following
+
+{{{#!sql
+SELECT 
+   COUNT(IF(fStartTime<'2000-01-01 00:00:00' AND fStopTime<'2000-01-01 00:00:00', 1, NULL)) AS 'BLOCKED',
+   COUNT(IF(ISNULL(fStartTime) AND ISNULL(fStopTime),                             1, NULL)) AS 'NOT-DONE', 
+   COUNT(IF(fStartTime>'2000-01-01 00:00:00' AND ISNULL(fStopTime),               1, NULL)) AS 'RUNNING', 
+   COUNT(IF(fStartTime>'2000-01-01 00:00:00' AND fStopTime>'2000-01-01 00:00:00' AND ISNULL(fReturnCode),     1, NULL)) AS 'SUCCESS', 
+   COUNT(IF(fStartTime>'2000-01-01 00:00:00' AND fStopTime>'2000-01-01 00:00:00' AND NOT ISNULL(fReturnCode), 1, NULL)) AS 'FAILED'
+FROM
+   StatusTable
+}}}