| 119 |
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 |
FROM DEVI_PROD.admin.software_issue si INNER JOIN DEVI_PROD.admin.statedef sdef ON si.state = sdef.id
|
|
|
12 |
WHERE si.dbid IN (/*DEVIiss*/)
|
|
|
13 |
UNION ALL
|
|
|
14 |
SELECT /*enumCLEARQUEST_TDSE_ID*/ AS iss_db,
|
|
|
15 |
si.dbid AS iss_id,
|
|
|
16 |
si.job_number AS iss_num,
|
|
|
17 |
si.problem_summary AS summary,
|
|
|
18 |
sdef.name AS status,
|
|
|
19 |
si.priority AS priority,
|
|
|
20 |
NULL AS issue_type
|
|
|
21 |
FROM TDSE_2002.admin.request si INNER JOIN TDSE_2002.admin.statedef sdef ON si.state = sdef.id
|
|
|
22 |
WHERE si.dbid IN (/*TDSEiss*/)
|
|
|
23 |
UNION ALL
|
|
|
24 |
SELECT /*enumCLEARQUEST_VT5DM_ID*/ AS iss_db,
|
|
|
25 |
si.dbid AS iss_id,
|
|
|
26 |
si.new_num AS iss_num,
|
|
|
27 |
si.headline AS summary,
|
|
|
28 |
sdef.name AS status,
|
|
|
29 |
si.priority AS priority,
|
|
|
30 |
si.issue_type AS issue_type
|
|
|
31 |
FROM VT5DM.admin.software_issue si INNER JOIN VT5DM.admin.statedef sdef ON si.state = sdef.id
|
|
|
32 |
WHERE si.dbid IN (/*VT5DMiss*/)
|
|
|
33 |
UNION ALL
|
|
|
34 |
SELECT /*enumCLEARQUEST_VTSUP_ID*/ AS iss_db,
|
|
|
35 |
si.dbid AS iss_id,
|
|
|
36 |
si.job_number AS iss_num,
|
|
|
37 |
si.problem_summary AS summary,
|
|
|
38 |
sdef.name AS status,
|
|
|
39 |
si.priority AS priority,
|
|
|
40 |
NULL AS issue_type
|
|
|
41 |
FROM VTSUP.admin.request si INNER JOIN VTSUP.admin.statedef sdef ON si.state = sdef.id
|
|
|
42 |
WHERE si.dbid IN (/*VTSUPiss*/)
|
|
|
43 |
|
|
|
44 |
) AS issues
|
|
|
45 |
ORDER BY iss_num ASC
|