Subversion Repositories DevTools

Rev

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

Rev 37 Rev 3947
Line 6... Line 6...
6 
		si.new_num AS iss_num,
 6 
		si.new_num AS iss_num,
7 
	    si.headline AS summary,
 7 
	    si.headline AS summary,
8 
		sdef.name AS status,
 8 
		sdef.name AS status,
9 
		si.priority AS priority,
 9 
		si.priority AS priority,
10 
		si.issue_type AS issue_type
 10 
		si.issue_type AS issue_type
11 
  FROM  CQ_DEVI.admin.software_issue si INNER JOIN CQ_DEVI.admin.statedef sdef ON si.state = sdef.id
 - 
 
12 
	WHERE  si.dbid IN (/*DEVIiss*/)
 - 
 
13 
	UNION ALL
 - 
 
14 
	SELECT /*enumCLEARQUEST_TDSE_ID*/ AS iss_db,
 - 
 
15 
          si.dbid AS iss_id,
 - 
 
16 
          si.job_number AS iss_num,
 - 
 
17 
          si.problem_summary AS summary,
 - 
 
18 
          sdef.name AS status,
 - 
 
19 
          si.priority AS priority,
 - 
 
20 
          NULL AS issue_type
 - 
 
21 
    FROM  CQ_TDSE.admin.request si INNER JOIN CQ_TDSE.admin.statedef sdef ON si.state = sdef.id
 - 
 
22 
	WHERE  si.dbid IN (/*TDSEiss*/)
 - 
 
23 
	UNION ALL
 - 
 
24 
	SELECT  /*enumCLEARQUEST_VT5DM_ID*/ AS iss_db,
 - 
 
25 
		si.dbid AS iss_id,
 - 
 
26 
		si.new_num AS iss_num,
 - 
 
27 
	    si.headline AS summary,
 - 
 
28 
		sdef.name AS status,
 - 
 
29 
		si.priority AS priority,
 - 
 
30 
		si.issue_type AS issue_type
 - 
 
31 
  FROM  CQ_VT5DM.admin.software_issue si INNER JOIN CQ_VT5DM.admin.statedef sdef ON si.state = sdef.id
 - 
 
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  CQ_VTSUP.admin.request si INNER JOIN CQ_VTSUP.admin.statedef sdef ON si.state = sdef.id
 - 
 
42 
	WHERE  si.dbid IN (/*VTSUPiss*/)
 - 
 
43 
 
 - 
 
44 
	) AS issues
 11 
	) AS issues
45 
ORDER BY iss_num ASC
 12 
ORDER BY iss_num ASC