| 4553 |
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 |
si.issue_type AS issue_type,
|
|
|
8 |
dbms_lob.substr( si.integration_notes, 4000, 1 )as int_notes,
|
|
|
9 |
dbms_lob.substr( si.codereview_reference, 4000, 1 )as cr_ref,
|
|
|
10 |
si.risk as risk,
|
|
|
11 |
si.related_database_patches as db_patches,
|
|
|
12 |
si.affected_packages as affected_packages
|
|
|
13 |
FROM CQ_software_issue si INNER JOIN CQ_statedef sdef ON si.state = sdef.id
|
|
|
14 |
WHERE si.dbid IN (/*DEVIiss*/)
|
| 159 |
ghuddy |
15 |
ORDER BY iss_num ASC
|