Subversion Repositories DevTools

Rev

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

/* VTSUP Issues List*/
SELECT
           si.dbid AS iss_id,
           si.job_number AS iss_num,
           si.problem_summary AS summary,
           sdef.name AS status,
           si.priority AS priority,
           'None' AS issue_type
  FROM CQ_VTSUP.admin.request si INNER JOIN CQ_VTSUP.admin.statedef sdef ON si.state = sdef.id
 WHERE si.dbid IN (/*VTSUPiss*/)
 ORDER BY iss_num ASC