Subversion Repositories DevTools

Rev

Rev 159 | Go to most recent revision | 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*/)
159 ghuddy 36 
 
119 ghuddy 37 
		UNION ALL
159 ghuddy 38 
 
39 
	   SELECT /*enumCLEARQUEST_TDSE_ID*/ AS iss_db,
40 
	   		  si.dbid AS iss_id,
41 
			  si.job_number AS iss_num,
42 
			  si.problem_summary AS summary,
43 
			  sdef.name AS status,
44 
			  si.priority AS priority,
119 ghuddy 45 
			  NULL AS releaseinfo,
159 ghuddy 46 
			  NULL AS issue_type,
47 
			  NULL AS release_part1,
48 
			  NULL AS release_part2,
49 
			  NULL AS release_part3,
50 
			  si.group_project AS project,
51 
	          si.category_main AS product,
52 
			  NULL AS package_ref,
53 
			  si.notes_log,
54 
			  si.description,
55 
			  si.release_id,
56 
			  si.client_ref,
57 
			  si.severity,
58 
	          si.change_request AS cr_internal,
59 
			  si.external_change_request AS cr_external,
60 
			  sp.fullname AS submitter,
61 
			  si.when_reported AS submit_date,
62 
	          ow.fullname AS owner,
119 ghuddy 63 
			  ap.fullname AS approver
159 ghuddy 64 
     FROM CQ_TDSE.admin.request si INNER JOIN
65 
            CQ_TDSE.admin.statedef sdef ON si.state = sdef.id INNER JOIN
66 
            CQ_TDSE.admin.users ow ON si.owner = ow.dbid INNER JOIN
67 
            CQ_TDSE.admin.users sp ON si.raised_by = sp.dbid INNER JOIN
68 
            CQ_TDSE.admin.users ap ON si.who_reported = ap.dbid
119 ghuddy 69 
		WHERE si.dbid IN (/*TDSEiss*/)
159 ghuddy 70 
 
71 
 
119 ghuddy 72 
	) AS issues
159 ghuddy 73 
ORDER BY iss_num ASC