Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
29 jtweddle 1 
SELECT *
2 
  FROM
3 
       (
37 brianf 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,
29 jtweddle 10 
			  si.priority AS priority,
11 
			  si.releaseinfo as releaseinfo,
12 
			  si.sbom as sbom,
37 brianf 13 
	          si.issue_type AS issue_type,
14 
			  si.release_part1,
15 
			  si.release_part2,
16 
			  si.release_part3,
17 
			  si.project,
18 
			  si.product,
19 
			  si.package_ref,
20 
			  si.notes_log,
21 
	          si.description,
22 
			  NULL AS release_id,
23 
			  NULL AS client_ref,
24 
			  NULL AS severity,
25 
			  NULL AS cr_internal,
26 
			  NULL AS cr_external,
27 
			  sp.fullname AS submitter,
28 
	          si.submit_date,
29 
			  ow.fullname AS owner,
29 jtweddle 30 
			  ap.fullname AS approver
37 brianf 31 
       FROM CQ_DEVI.admin.software_issue si INNER JOIN
32 
            CQ_DEVI.admin.statedef sdef ON si.state = sdef.id INNER JOIN
33 
            CQ_DEVI.admin.users sp ON si.submitter = sp.dbid INNER JOIN
34 
            CQ_DEVI.admin.users ow ON si.owner = ow.dbid INNER JOIN
35 
            CQ_DEVI.admin.users ap ON si.approver = ap.dbid
29 jtweddle 36 
		WHERE si.dbid IN (/*DEVIiss*/)
37 brianf 37 
 
29 jtweddle 38 
	) AS issues
37 brianf 39 
ORDER BY iss_num ASC