Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
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 
    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*/)
37 brianf 11 
ORDER BY iss_num ASC