| 4554 |
dpurdie |
1 |
SELECT /*enumCLEARQUEST_DEVI_ID*/ AS iss_db,
|
|
|
2 |
si.dbid AS iss_id,
|
|
|
3 |
si.new_num AS iss_num,
|
|
|
4 |
si.headline AS summary,
|
|
|
5 |
sdef.name AS status,
|
|
|
6 |
si.priority AS priority,
|
|
|
7 |
dbms_lob.substr( si.releaseinfo, 4000, 1 )as releaseinfo,
|
|
|
8 |
si.sbom as sbom,
|
|
|
9 |
si.issue_type AS issue_type,
|
|
|
10 |
si.release_part1,
|
|
|
11 |
si.release_part2,
|
|
|
12 |
si.release_part3,
|
|
|
13 |
si.project,
|
|
|
14 |
si.product,
|
|
|
15 |
si.package_ref,
|
|
|
16 |
dbms_lob.substr( si.notes_log, 4000, 1 ) AS notes_log,
|
|
|
17 |
dbms_lob.substr( si.description, 4000, 1 )AS description,
|
|
|
18 |
NULL AS release_id,
|
|
|
19 |
NULL AS client_ref,
|
|
|
20 |
NULL AS severity,
|
|
|
21 |
NULL AS cr_internal,
|
|
|
22 |
NULL AS cr_external,
|
|
|
23 |
sp.fullname AS submitter,
|
|
|
24 |
si.submit_date,
|
|
|
25 |
ow.fullname AS owner,
|
|
|
26 |
ap.fullname AS approver
|
|
|
27 |
FROM release_manager.CQ_software_issue si INNER JOIN
|
|
|
28 |
release_manager.CQ_statedef sdef ON si.state = sdef.id INNER JOIN
|
|
|
29 |
release_manager.CQ_users sp ON si.submitter = sp.dbid INNER JOIN
|
|
|
30 |
release_manager.CQ_users ow ON si.owner = ow.dbid INNER JOIN
|
|
|
31 |
release_manager.CQ_users ap ON si.approver = ap.dbid
|
|
|
32 |
WHERE si.dbid IN (/*DEVIiss*/)
|
| 37 |
brianf |
33 |
ORDER BY iss_num ASC
|