Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT p.proj_id,
2 
       p.proj_name,
3 
       rt.rtag_name,
4 
       rm.rtag_id,
5 
       rm.total_packages,
6 
       rm.autobuilt,
7 
       rm.lines_of_code,
8 
       rm.unit_tested,
9 
       rm.autotested,
10 
       CASE
11 
         WHEN rm.branches = 0 THEN NULL ELSE rm.branches
12 
       END AS branches,
13 
       rm.last_build_time
14 
  FROM projects p,
15 
       release_metrics rm,
16 
       release_tags rt
17 
 WHERE p.proj_id = rt.proj_id
18 
   AND rm.rtag_id = rt.rtag_id
19 
   AND p.proj_id = :PROJ_ID
20 
 ORDER BY
21 
       CASE
22 
         WHEN rm.last_build_time IS NULL THEN 2 ELSE 1
23 
       END,
24 
       UPPER(rt.rtag_name),
25 
       rm.last_build_time DESC,
26 
       rm.rtag_id DESC