| 13 |
rsolanki |
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 |
) AS issues
|
|
|
34 |
ORDER BY iss_num ASC
|