Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
4556 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 
 FROM  release_manager.CQ_software_issue si INNER JOIN
9 
       release_manager.CQ_statedef sdef ON si.state = sdef.id
10 
 WHERE  si.dbid IN (/*DEVIiss*/)
11 
 ORDER BY iss_num ASC