Subversion Repositories DevTools

Rev

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

Rev 13 Rev 23
Line 28... Line 28...
28 
		sdef.name AS status,
28 
		sdef.name AS status,
29 
		si.priority AS priority,
 29 
		si.priority AS priority,
30 
		si.issue_type AS issue_type
 30 
		si.issue_type AS issue_type
31 
	FROM  VT5DM.admin.software_issue si INNER JOIN VT5DM.admin.statedef sdef ON si.state = sdef.id
 31 
	FROM  VT5DM.admin.software_issue si INNER JOIN VT5DM.admin.statedef sdef ON si.state = sdef.id
32 
	WHERE  si.dbid IN (/*VT5DMiss*/)
 32 
	WHERE  si.dbid IN (/*VT5DMiss*/)
- 
 
 33 
	UNION ALL
- 
 
 34 
	SELECT /*enumCLEARQUEST_VTSUP_ID*/ AS iss_db,
- 
 
 35 
          si.dbid AS iss_id,
- 
 
 36 
          si.job_number AS iss_num,
- 
 
 37 
          si.problem_summary AS summary,
- 
 
 38 
          sdef.name AS status,
- 
 
 39 
          si.priority AS priority,
- 
 
 40 
          NULL AS issue_type
- 
 
 41 
    FROM  VTSUP.admin.request si INNER JOIN VTSUP.admin.statedef sdef ON si.state = sdef.id
- 
 
 42 
	WHERE  si.dbid IN (/*VTSUPiss*/)
- 
 
 43 
 
33 
	) AS issues
 44 
	) AS issues
34 
ORDER BY iss_num ASC
 45 
ORDER BY iss_num ASC
35 

            46