Subversion Repositories DevTools

Rev

Rev 70 | Go to most recent revision | 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
70 brianf 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 
	UNION ALL
14 
	SELECT /*enumCLEARQUEST_TDSE_ID*/ AS iss_db,
70 brianf 15 
          si.dbid AS iss_id,
16 
          si.job_number AS iss_num,
17 
          si.problem_summary AS summary,
18 
          sdef.name AS status,
64 jtweddle 19 
          si.priority AS priority,
20 
          NULL AS issue_type
70 brianf 21 
    FROM  CQ_TDSE.admin.request si INNER JOIN CQ_TDSE.admin.statedef sdef ON si.state = sdef.id
64 jtweddle 22 
	WHERE  si.dbid IN (/*TDSEiss*/)
23 
	UNION ALL
24 
	SELECT  /*enumCLEARQUEST_VT5DM_ID*/ AS iss_db,
70 brianf 25 
		si.dbid AS iss_id,
26 
		si.new_num AS iss_num,
27 
	    si.headline AS summary,
28 
		sdef.name AS status,
64 jtweddle 29 
		si.priority AS priority,
30 
		si.issue_type AS issue_type
70 brianf 31 
  FROM  CQ_VT5DM.admin.software_issue si INNER JOIN CQ_VT5DM.admin.statedef sdef ON si.state = sdef.id
64 jtweddle 32 
	WHERE  si.dbid IN (/*VT5DMiss*/)
33 
	UNION ALL
34 
	SELECT /*enumCLEARQUEST_VTSUP_ID*/ AS iss_db,
70 brianf 35 
          si.dbid AS iss_id,
36 
          si.job_number AS iss_num,
37 
          si.problem_summary AS summary,
38 
          sdef.name AS status,
64 jtweddle 39 
          si.priority AS priority,
40 
          NULL AS issue_type
70 brianf 41 
    FROM  CQ_VTSUP.admin.request si INNER JOIN CQ_VTSUP.admin.statedef sdef ON si.state = sdef.id
64 jtweddle 42 
	WHERE  si.dbid IN (/*VTSUPiss*/)
43 
 
44 
	) AS issues
70 brianf 45 
ORDER BY iss_num ASC