Subversion Repositories DevTools

Rev

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

Rev 6576 Rev 6577
Line 8... Line 8...
8 
and bi.reason not in ('T')
 8 
and bi.reason not in ('T')
9 
group by pv_id
 9 
group by pv_id
10 
)
 10 
)
11 
select rc.pv_id,cbi.build_id, pv.pkg_id, p.PKG_NAME, pv.V_EXT, p.PKG_NAME || pv.V_EXT as pkg_alias, pv.PKG_VERSION,
 11 
select rc.pv_id,cbi.build_id, pv.pkg_id, p.PKG_NAME, pv.V_EXT, p.PKG_NAME || pv.V_EXT as pkg_alias, pv.PKG_VERSION,
12 
  (select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count,
12 
  (select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count,
13 
  TO_CHAR(bi.timestamp,'DD-Mon-YYYY HH24:MI:SS') AS lastBuild
 13 
  TO_CHAR(bi.timestamp,'DD-Mon-YYYY HH24:MI:SS') AS lastBuild, pv.build_time
14 
from RELEASE_CONTENT rc, PACKAGE_VERSIONS pv, packages p, CLEAN_BI cbi, BUILD_INSTANCES bi
 14 
from RELEASE_CONTENT rc, PACKAGE_VERSIONS pv, packages p, CLEAN_BI cbi, BUILD_INSTANCES bi
15 
where rc.RTAG_ID = :RTAG_ID
 15 
where rc.RTAG_ID = :RTAG_ID
16 
and rc.pv_id = pv.pv_id
 16 
and rc.pv_id = pv.pv_id
17 
and p.pkg_id = pv.pkg_id
 17 
and p.pkg_id = pv.pkg_id
18 
and cbi.pv_id = pv.pv_id
 18 
and cbi.pv_id = pv.pv_id