| 119 |
ghuddy |
1 |
SELECT *
|
|
|
2 |
FROM
|
|
|
3 |
(
|
|
|
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,
|
|
|
10 |
si.priority AS priority,
|
|
|
11 |
si.releaseinfo as releaseinfo,
|
|
|
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,
|
|
|
29 |
ap.fullname AS approver
|
|
|
30 |
FROM DEVI_PROD.admin.software_issue si INNER JOIN
|
|
|
31 |
DEVI_PROD.admin.statedef sdef ON si.state = sdef.id INNER JOIN
|
|
|
32 |
DEVI_PROD.admin.users sp ON si.submitter = sp.dbid INNER JOIN
|
|
|
33 |
DEVI_PROD.admin.users ow ON si.owner = ow.dbid INNER JOIN
|
|
|
34 |
DEVI_PROD.admin.users ap ON si.approver = ap.dbid
|
|
|
35 |
WHERE si.dbid IN (/*DEVIiss*/)
|
|
|
36 |
|
|
|
37 |
UNION ALL
|
|
|
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,
|
|
|
45 |
NULL AS releaseinfo,
|
|
|
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,
|
|
|
63 |
ap.fullname AS approver
|
|
|
64 |
FROM TDSE_2002.admin.request si INNER JOIN
|
|
|
65 |
TDSE_2002.admin.statedef sdef ON si.state = sdef.id INNER JOIN
|
|
|
66 |
TDSE_2002.admin.users ow ON si.owner = ow.dbid INNER JOIN
|
|
|
67 |
TDSE_2002.admin.users sp ON si.raised_by = sp.dbid INNER JOIN
|
|
|
68 |
TDSE_2002.admin.users ap ON si.who_reported = ap.dbid
|
|
|
69 |
WHERE si.dbid IN (/*TDSEiss*/)
|
|
|
70 |
|
|
|
71 |
|
|
|
72 |
) AS issues
|
|
|
73 |
ORDER BY iss_num ASC
|