Subversion Repositories DevTools

Rev

Rev 13 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 13 Rev 37
Line 1... Line 1...
1 
/* DEVI Isseus List*/
 1 
/* DEVI Isseus List*/
2 
SELECT
2 
SELECT
3 
	   si.dbid AS iss_id,
3 
	   si.dbid AS iss_id,
4 
	   si.new_num AS iss_num,
4 
	   si.new_num AS iss_num,
5 
       si.headline AS summary,
5 
       si.headline AS summary,
6 
	   sdef.name AS status,
6 
	   sdef.name AS status,
7 
	   si.priority AS priority,
 7 
	   si.priority AS priority,
8 
	   si.issue_type AS issue_type
 8 
	   si.issue_type AS issue_type
9 
  FROM DEVI_PROD.admin.software_issue si INNER JOIN DEVI_PROD.admin.statedef sdef ON si.state = sdef.id
 9 
  FROM CQ_DEVI.admin.software_issue si INNER JOIN CQ_DEVI.admin.statedef sdef ON si.state = sdef.id
10 
 WHERE si.dbid IN (/*DEVIiss*/)
 10 
 WHERE si.dbid IN (/*DEVIiss*/)
11 
 ORDER BY iss_num ASC
11 
 ORDER BY iss_num ASC
12
12