Subversion Repositories DevTools

Rev

Rev 70 | Blame | Compare with Previous | Last modification | View Log | RSS feed 

/* DEVI Isseus List*/
SELECT
           si.dbid AS iss_id,
           si.new_num AS iss_num,
       si.headline AS summary,
           sdef.name AS status,
           si.priority AS priority,
           si.issue_type AS issue_type
  FROM CQ_DEVI.admin.software_issue si INNER JOIN CQ_DEVI.admin.statedef sdef ON si.state = sdef.id
 WHERE si.dbid IN (/*DEVIiss*/)
 ORDER BY iss_num ASC