Subversion Repositories DevTools

Rev

Rev 4553 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
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