Subversion Repositories DevTools

Rev

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

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

            75
            
ORDER BY iss_num ASC

          

          

            -
            
 

            76