Changes between Version 20 and Version 21 of DatabaseBasedAnalysis/Tables


Ignore:
Timestamp:
09/03/18 18:46:14 (7 years ago)
Author:
tbretz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DatabaseBasedAnalysis/Tables

    v20 v21  
    8383{{{#!sql
    8484SELECT
    85    COUNT(IF(fStartTime<'2000-01-01 00:00:00' AND fStopTime<'2000-01-01 00:00:00', 1, NULL)) AS 'BLOCKED',
    86    COUNT(IF(ISNULL(fStartTime) AND ISNULL(fStopTime),                             1, NULL)) AS 'NOT-DONE',
    87    COUNT(IF(fStartTime>'2000-01-01 00:00:00' AND ISNULL(fStopTime),               1, NULL)) AS 'RUNNING',
     85   COUNT(IF(ISNULL(fStartTime) AND ISNULL(fStopTime),                                                         1, NULL)) AS 'NOT-DONE',
     86   COUNT(IF(fStartTime>'2000-01-01 00:00:00' AND ISNULL(fStopTime),                                           1, NULL)) AS 'RUNNING',
    8887   COUNT(IF(fStartTime>'2000-01-01 00:00:00' AND fStopTime>'2000-01-01 00:00:00' AND ISNULL(fReturnCode),     1, NULL)) AS 'SUCCESS',
    89    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'
     88   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',
     89   COUNT(IF(fStartTime<'2000-01-01 00:00:00' AND fStopTime<'2000-01-01 00:00:00',                             1, NULL)) AS 'BLOCKED'
    9090FROM
    9191   StatusTable