Subversion Repositories DevTools

Rev

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

Rev 3975 Rev 4553
Line 1... Line -...
1 
SELECT *
 - 
 
2 
  FROM
 - 
 
3 
       (
 - 
 
4 
	SELECT  /*enumCLEARQUEST_DEVI_ID*/ AS iss_db,
 1 
SELECT  /*enumCLEARQUEST_DEVI_ID*/ AS iss_db,
5 
		si.dbid AS iss_id,
 2 
    si.dbid AS iss_id,
6 
		si.new_num AS iss_num,
 3 
    si.new_num AS iss_num,
7 
	    si.headline AS summary,
 4 
    si.headline AS summary,
8 
		sdef.name AS status,
 5 
    sdef.name AS status,
9 
		si.priority AS priority,
 6 
    si.priority AS priority,
10 
        si.issue_type AS issue_type,
 7 
    si.issue_type AS issue_type,
11 
        si.integration_notes AS int_notes,
 8 
    dbms_lob.substr( si.integration_notes, 4000, 1 )as int_notes,
12 
        si.codereview_reference AS cr_ref,
 9 
    dbms_lob.substr( si.codereview_reference, 4000, 1 )as cr_ref,
13 
        si.risk as risk,
 10 
    si.risk as risk,
14 
        si.related_database_patches as db_patches,
 11 
    si.related_database_patches as db_patches,
15 
        si.affected_packages as affected_packages
 12 
    si.affected_packages as affected_packages
16 
	FROM  CQ_DEVI.admin.software_issue si INNER JOIN CQ_DEVI.admin.statedef sdef ON si.state = sdef.id
 13 
FROM  CQ_software_issue si INNER JOIN CQ_statedef sdef ON si.state = sdef.id
17 
	WHERE  si.dbid IN (/*DEVIiss*/)
 14 
WHERE  si.dbid IN (/*DEVIiss*/)
18 
	) AS issues
 - 
 
19 
ORDER BY iss_num ASC
 15 
ORDER BY iss_num ASC