Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
64 jtweddle 1 
SELECT *
2 
  FROM
3 
       (
4 
	SELECT  /*enumCLEARQUEST_DEVI_ID*/ AS iss_db,
70 brianf 5 
		si.dbid AS iss_id,
6 
		si.new_num AS iss_num,
7 
	    si.headline AS summary,
8 
		sdef.name AS status,
64 jtweddle 9 
		si.priority AS priority,
10 
		si.issue_type AS issue_type
4012 dpurdie 11 
    FROM  CQ_DEVI.admin.software_issue si INNER JOIN CQ_DEVI.admin.statedef sdef ON si.state = sdef.id
64 jtweddle 12 
	WHERE  si.dbid IN (/*DEVIiss*/)
13 
 
14 
	) AS issues
70 brianf 15 
ORDER BY iss_num ASC