| 159 |
ghuddy |
1 |
SELECT *
|
|
|
2 |
FROM
|
|
|
3 |
(
|
|
|
4 |
SELECT /*enumCLEARQUEST_DEVI_ID*/ AS iss_db,
|
|
|
5 |
si.dbid AS iss_id,
|
|
|
6 |
si.new_num AS iss_num,
|
|
|
7 |
si.headline AS summary,
|
|
|
8 |
sdef.name AS status,
|
|
|
9 |
si.priority AS priority,
|
|
|
10 |
si.issue_type AS issue_type,
|
|
|
11 |
si.integration_notes AS int_notes,
|
|
|
12 |
si.codereview_reference AS cr_ref,
|
|
|
13 |
si.risk as risk,
|
|
|
14 |
si.related_database_patches as db_patches,
|
|
|
15 |
si.affected_packages as affected_packages
|
|
|
16 |
FROM CQ_DEVI.admin.software_issue si INNER JOIN CQ_DEVI.admin.statedef sdef ON si.state = sdef.id
|
|
|
17 |
WHERE si.dbid IN (/*DEVIiss*/)
|
|
|
18 |
UNION ALL
|
|
|
19 |
SELECT /*enumCLEARQUEST_TDSE_ID*/ AS iss_db,
|
|
|
20 |
si.dbid AS iss_id,
|
|
|
21 |
si.job_number AS iss_num,
|
|
|
22 |
si.problem_summary AS summary,
|
|
|
23 |
sdef.name AS status,
|
|
|
24 |
si.priority AS priority,
|
|
|
25 |
NULL AS issue_type,
|
|
|
26 |
NULL AS int_notes,
|
|
|
27 |
NULL AS cr_ref,
|
|
|
28 |
NULL AS risk,
|
|
|
29 |
NULL AS db_patches,
|
|
|
30 |
NULL AS affected_packages
|
|
|
31 |
FROM CQ_TDSE.admin.request si INNER JOIN CQ_TDSE.admin.statedef sdef ON si.state = sdef.id
|
|
|
32 |
WHERE si.dbid IN (/*TDSEiss*/)
|
|
|
33 |
UNION ALL
|
|
|
34 |
SELECT /*enumCLEARQUEST_VT5DM_ID*/ AS iss_db,
|
|
|
35 |
si.dbid AS iss_id,
|
|
|
36 |
si.new_num AS iss_num,
|
|
|
37 |
si.headline AS summary,
|
|
|
38 |
sdef.name AS status,
|
|
|
39 |
si.priority AS priority,
|
|
|
40 |
si.issue_type AS issue_type,
|
|
|
41 |
NULL AS int_notes,
|
|
|
42 |
NULL AS cr_ref,
|
|
|
43 |
NULL AS risk,
|
|
|
44 |
NULL AS db_patches,
|
|
|
45 |
NULL AS affected_packages
|
|
|
46 |
FROM CQ_VT5DM.admin.software_issue si INNER JOIN CQ_VT5DM.admin.statedef sdef ON si.state = sdef.id
|
|
|
47 |
WHERE si.dbid IN (/*VT5DMiss*/)
|
|
|
48 |
UNION ALL
|
|
|
49 |
SELECT /*enumCLEARQUEST_VTSUP_ID*/ AS iss_db,
|
|
|
50 |
si.dbid AS iss_id,
|
|
|
51 |
si.job_number AS iss_num,
|
|
|
52 |
si.problem_summary AS summary,
|
|
|
53 |
sdef.name AS status,
|
|
|
54 |
si.priority AS priority,
|
|
|
55 |
NULL AS issue_type,
|
|
|
56 |
NULL AS int_notes,
|
|
|
57 |
NULL AS cr_ref,
|
|
|
58 |
NULL AS risk,
|
|
|
59 |
NULL AS db_patches,
|
|
|
60 |
NULL AS affected_packages
|
|
|
61 |
FROM CQ_VTSUP.admin.request si INNER JOIN CQ_VTSUP.admin.statedef sdef ON si.state = sdef.id
|
|
|
62 |
WHERE si.dbid IN (/*VTSUPiss*/)
|
|
|
63 |
|
|
|
64 |
) AS issues
|
|
|
65 |
ORDER BY iss_num ASC
|