Subversion Repositories DevTools

Rev

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

Rev 6707 Rev 6873
Line 14... Line 14...
14 
    pm.code_lines,
 14 
    pm.code_lines,
15 
    (CASE bi.reason WHEN 'R' THEN 'Ripple' WHEN 'N' THEN 'New Version' WHEN 'T' THEN 'Test' WHEN 'P' THEN 'Restored' ELSE '' END ) as reason,
 15 
    (CASE bi.reason WHEN 'R' THEN 'Ripple' WHEN 'N' THEN 'New Version' WHEN 'T' THEN 'Test' WHEN 'P' THEN 'Restored' ELSE '' END ) as reason,
16 
    bi.state,
 16 
    bi.state,
17 
    (select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count,
 17 
    (select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count,
18 
    pv.build_time,
 18 
    pv.build_time,
19 
    pln.NAME as licence
 19 
    pln.NAME as licence,
- 
 
 20 
    pv.pkg_idext,
- 
 
 21 
    pv.build_type
20 
  FROM PACKAGE_VERSIONS pv,
 22 
  FROM PACKAGE_VERSIONS pv,
21 
       USERS usr,
 23 
       USERS usr,
22 
       RELEASE_CONTENT rc,
 24 
       RELEASE_CONTENT rc,
23 
       ( select pv_id, max(build_id) as build_id  from BUILD_INSTANCES bi
 25 
       ( select pv_id, max(build_id) as build_id  from BUILD_INSTANCES bi
24 
          where bi.state in ('C')
 26 
          where bi.state in ('C')