Subversion Repositories DevTools

Rev

Rev 6873 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6873 Rev 7162
Line 133... Line 133...
133 
        "  COUNT(reason)   AS rc," &_
 133 
        "  COUNT(reason)   AS rc," &_
134 
        "  SUM(test_count) AS tc" &_
 134 
        "  SUM(test_count) AS tc" &_
135 
        " FROM" &_
 135 
        " FROM" &_
136 
        "  (SELECT pj.PROJ_NAME," &_
 136 
        "  (SELECT pj.PROJ_NAME," &_
137 
        "    RTAG_NAME," &_
 137 
        "    RTAG_NAME," &_
138 
        "    DECODE(bi.reason, 'N', 'NewVersion', 'R', 'Ripple', 'T', 'Test', 'P', 'Restored', 'Unknown') as REASON," &_
 138 
        "    DECODE(bi.reason, 'N', 'NewVersion', 'R', 'Ripple', 'T', 'Test', 'P', 'Restored', 'F', 'ForcedRipple', 'Unknown') as REASON," &_
139 
        "    DECODE(bi.state, 'B', 'Buiding', 'C', 'Complete', 'E', 'Error', 'S', 'SysErr', 'Unknown') as STATE," &_
 139 
        "    DECODE(bi.state, 'B', 'Buiding', 'C', 'Complete', 'E', 'Error', 'S', 'SysErr', 'Unknown') as STATE," &_
140 
        "    (SELECT COUNT(*) FROM TEST_RUN tr WHERE tr.build_id = bi.build_id ) AS test_count" &_
 140 
        "    (SELECT COUNT(*) FROM TEST_RUN tr WHERE tr.build_id = bi.build_id ) AS test_count" &_
141 
        "  FROM BUILD_INSTANCES bi," &_
 141 
        "  FROM BUILD_INSTANCES bi," &_
142 
        "    projects pj," &_
 142 
        "    projects pj," &_
143 
        "    RELEASE_TAGS rt" &_
 143 
        "    RELEASE_TAGS rt" &_