Subversion Repositories DevTools

Rev

Rev 6585 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6585 Rev 6873
Line 139... Line 139...
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" &_
144 
        "  WHERE bi.RTAG_ID = rt.RTAG_ID" &_
 144 
        "  WHERE bi.RTAG_ID = rt.RTAG_ID(+)" &_
145 
        "  AND rt.proj_id   = pj.proj_id" & limit &_
 145 
        "  AND rt.proj_id   = pj.proj_id(+)" & limit &_
146 
        "  ) group by proj_name, rtag_name, state, reason" &_
 146 
        "  ) group by proj_name, rtag_name, state, reason" &_
147 
        " ORDER BY PROJ_NAME, rtag_name,  state,  reason"
 147 
        " ORDER BY PROJ_NAME, rtag_name,  state,  reason"
148 
 
 148 
 
149 
    On Error Resume Next
 149 
    On Error Resume Next
150 
    objEH.ErrorRedirect = FALSE
 150 
    objEH.ErrorRedirect = FALSE