Subversion Repositories DevTools

Rev

Rev 119 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 119 Rev 159
Line 1... Line 1...
1 
SELECT *
 1 
SELECT *
2 
  FROM
 2 
  FROM
3 
       (
 3 
       (
4
4 
 
5 
	   SELECT /*enumCLEARQUEST_DEVI_ID*/ AS iss_db,
5 
	   SELECT /*enumCLEARQUEST_DEVI_ID*/ AS iss_db,
6 
	          si.dbid AS iss_id,
6 
	          si.dbid AS iss_id,
7 
			  si.new_num AS iss_num,
7 
			  si.new_num AS iss_num,
8 
			  si.headline AS summary,
8 
			  si.headline AS summary,
9 
			  sdef.name AS status,
9 
			  sdef.name AS status,
10 
			  si.priority AS priority,
 10 
			  si.priority AS priority,
11 
			  si.releaseinfo as releaseinfo,
 11 
			  si.releaseinfo as releaseinfo,
12 
	          si.issue_type AS issue_type,
12 
	          si.issue_type AS issue_type,
13 
			  si.release_part1,
13 
			  si.release_part1,
14 
			  si.release_part2,
14 
			  si.release_part2,
15 
			  si.release_part3,
15 
			  si.release_part3,
16 
			  si.project,
16 
			  si.project,
17 
			  si.product,
17 
			  si.product,
18 
			  si.package_ref,
18 
			  si.package_ref,
19 
			  si.notes_log,
19 
			  si.notes_log,
20 
	          si.description,
20 
	          si.description,
21 
			  NULL AS release_id,
21 
			  NULL AS release_id,
22 
			  NULL AS client_ref,
22 
			  NULL AS client_ref,
23 
			  NULL AS severity,
23 
			  NULL AS severity,
24 
			  NULL AS cr_internal,
24 
			  NULL AS cr_internal,
25 
			  NULL AS cr_external,
25 
			  NULL AS cr_external,
26 
			  sp.fullname AS submitter,
26 
			  sp.fullname AS submitter,
27 
	          si.submit_date,
27 
	          si.submit_date,
28 
			  ow.fullname AS owner,
28 
			  ow.fullname AS owner,
29 
			  ap.fullname AS approver
 29 
			  ap.fullname AS approver
30 
	     FROM DEVI_PROD.admin.software_issue si INNER JOIN
 30 
       FROM CQ_DEVI.admin.software_issue si INNER JOIN
31 
	          DEVI_PROD.admin.statedef sdef ON si.state = sdef.id INNER JOIN
 31 
            CQ_DEVI.admin.statedef sdef ON si.state = sdef.id INNER JOIN
32 
	          DEVI_PROD.admin.users sp ON si.submitter = sp.dbid INNER JOIN
 32 
            CQ_DEVI.admin.users sp ON si.submitter = sp.dbid INNER JOIN
33 
	          DEVI_PROD.admin.users ow ON si.owner = ow.dbid INNER JOIN
 33 
            CQ_DEVI.admin.users ow ON si.owner = ow.dbid INNER JOIN
34 
	          DEVI_PROD.admin.users ap ON si.approver = ap.dbid
 34 
            CQ_DEVI.admin.users ap ON si.approver = ap.dbid
35 
		WHERE si.dbid IN (/*DEVIiss*/)
 35 
		WHERE si.dbid IN (/*DEVIiss*/)
36
36 
 
37 
		UNION ALL
 37 
		UNION ALL
38
38 
 
39 
	   SELECT /*enumCLEARQUEST_TDSE_ID*/ AS iss_db,
39 
	   SELECT /*enumCLEARQUEST_TDSE_ID*/ AS iss_db,
40 
	   		  si.dbid AS iss_id,
40 
	   		  si.dbid AS iss_id,
41 
			  si.job_number AS iss_num,
41 
			  si.job_number AS iss_num,
42 
			  si.problem_summary AS summary,
42 
			  si.problem_summary AS summary,
43 
			  sdef.name AS status,
43 
			  sdef.name AS status,
44 
			  si.priority AS priority,
44 
			  si.priority AS priority,
45 
			  NULL AS releaseinfo,
 45 
			  NULL AS releaseinfo,
46 
			  NULL AS issue_type,
46 
			  NULL AS issue_type,
47 
			  NULL AS release_part1,
47 
			  NULL AS release_part1,
48 
			  NULL AS release_part2,
48 
			  NULL AS release_part2,
49 
			  NULL AS release_part3,
49 
			  NULL AS release_part3,
50 
			  si.group_project AS project,
50 
			  si.group_project AS project,
51 
	          si.category_main AS product,
51 
	          si.category_main AS product,
52 
			  NULL AS package_ref,
52 
			  NULL AS package_ref,
53 
			  si.notes_log,
53 
			  si.notes_log,
54 
			  si.description,
54 
			  si.description,
55 
			  si.release_id,
55 
			  si.release_id,
56 
			  si.client_ref,
56 
			  si.client_ref,
57 
			  si.severity,
57 
			  si.severity,
58 
	          si.change_request AS cr_internal,
58 
	          si.change_request AS cr_internal,
59 
			  si.external_change_request AS cr_external,
59 
			  si.external_change_request AS cr_external,
60 
			  sp.fullname AS submitter,
60 
			  sp.fullname AS submitter,
61 
			  si.when_reported AS submit_date,
61 
			  si.when_reported AS submit_date,
62 
	          ow.fullname AS owner,
62 
	          ow.fullname AS owner,
63 
			  ap.fullname AS approver
 63 
			  ap.fullname AS approver
64 
		 FROM TDSE_2002.admin.request si INNER JOIN
 64 
     FROM CQ_TDSE.admin.request si INNER JOIN
65 
	          TDSE_2002.admin.statedef sdef ON si.state = sdef.id INNER JOIN
 65 
            CQ_TDSE.admin.statedef sdef ON si.state = sdef.id INNER JOIN
66 
	          TDSE_2002.admin.users ow ON si.owner = ow.dbid INNER JOIN
 66 
            CQ_TDSE.admin.users ow ON si.owner = ow.dbid INNER JOIN
67 
	          TDSE_2002.admin.users sp ON si.raised_by = sp.dbid INNER JOIN
 67 
            CQ_TDSE.admin.users sp ON si.raised_by = sp.dbid INNER JOIN
68 
	          TDSE_2002.admin.users ap ON si.who_reported = ap.dbid
 68 
            CQ_TDSE.admin.users ap ON si.who_reported = ap.dbid
69 
		WHERE si.dbid IN (/*TDSEiss*/)
 69 
		WHERE si.dbid IN (/*TDSEiss*/)
70
70 
 
71
71 
 
72 
	) AS issues
 72 
	) AS issues
73 
ORDER BY iss_num ASC
 - 
 
74 

            73
            
ORDER BY iss_num ASC

          

          

            -
            
 

            74