Changes between Version 23 and Version 24 of DatabaseBasedAnalysis/Tables


Ignore:
Timestamp:
09/03/18 18:49:40 (7 years ago)
Author:
tbretz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DatabaseBasedAnalysis/Tables

    v23 v24  
    8383{{{#!sql
    8484SELECT
    85    COUNT(IF(ISNULL(fStartTime) AND ISNULL(fStopTime),                                                         1, NULL)) AS 'WAITING',
     85   COUNT(IF(ISNULL(fStartTime)               AND ISNULL(fStopTime),                                           1, NULL)) AS 'WAITING',
    8686   COUNT(IF(fStartTime>'2000-01-01 00:00:00' AND ISNULL(fStopTime),                                           1, NULL)) AS 'RUNNING',
    87    COUNT(IF(fStartTime>'2000-01-01 00:00:00' AND fStopTime>'2000-01-01 00:00:00' AND ISNULL(fReturnCode),    1, NULL)) AS 'SUCCESS',
     87   COUNT(IF(fStartTime>'2000-01-01 00:00:00' AND fStopTime>'2000-01-01 00:00:00' AND     ISNULL(fReturnCode), 1, NULL)) AS 'SUCCESS',
    8888   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',
    8989   COUNT(IF(fStartTime<'2000-01-01 00:00:00' AND fStopTime<'2000-01-01 00:00:00',                             1, NULL)) AS 'BLOCKED'