Subversion Repositories DevTools

Rev

Rev 1281 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT *
2 
  FROM
3 
       (
159 ghuddy 4 
 
5 
	   SELECT /*enumCLEARQUEST_DEVI_ID*/ AS iss_db,
6 
	          si.dbid AS iss_id,
7 
			  si.new_num AS iss_num,
8 
			  si.headline AS summary,
9 
			  sdef.name AS status,
119 ghuddy 10 
			  si.priority AS priority,
11 
			  si.releaseinfo as releaseinfo,
159 ghuddy 12 
	          si.issue_type AS issue_type,
13 
			  si.release_part1,
14 
			  si.release_part2,
15 
			  si.release_part3,
16 
			  si.project,
17 
			  si.product,
18 
			  si.package_ref,
19 
			  si.notes_log,
20 
	          si.description,
21 
			  NULL AS release_id,
22 
			  NULL AS client_ref,
23 
			  NULL AS severity,
24 
			  NULL AS cr_internal,
25 
			  NULL AS cr_external,
26 
			  sp.fullname AS submitter,
27 
	          si.submit_date,
28 
			  ow.fullname AS owner,
119 ghuddy 29 
			  ap.fullname AS approver
159 ghuddy 30 
       FROM CQ_DEVI.admin.software_issue si INNER JOIN
31 
            CQ_DEVI.admin.statedef sdef ON si.state = sdef.id INNER JOIN
32 
            CQ_DEVI.admin.users sp ON si.submitter = sp.dbid INNER JOIN
33 
            CQ_DEVI.admin.users ow ON si.owner = ow.dbid INNER JOIN
34 
            CQ_DEVI.admin.users ap ON si.approver = ap.dbid
119 ghuddy 35 
		WHERE si.dbid IN (/*DEVIiss*/)
36 
	) AS issues
159 ghuddy 37 
ORDER BY iss_num ASC