Subversion Repositories DevTools

Rev

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

Rev 23 Rev 37
Line 1... Line 1...
1 
SELECT *
 1 
SELECT *
2 
  FROM
 2 
  FROM
3 
       (
 3 
       (
4 
	SELECT  /*enumCLEARQUEST_DEVI_ID*/ AS iss_db,
 4 
	SELECT  /*enumCLEARQUEST_DEVI_ID*/ AS iss_db,
5 
		si.dbid AS iss_id,
5 
		si.dbid AS iss_id,
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  DEVI_PROD.admin.software_issue si INNER JOIN DEVI_PROD.admin.statedef sdef ON si.state = sdef.id
 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*/)
 12 
	WHERE  si.dbid IN (/*DEVIiss*/)
13 
	UNION ALL
 13 
	UNION ALL
14 
	SELECT /*enumCLEARQUEST_TDSE_ID*/ AS iss_db,
 14 
	SELECT /*enumCLEARQUEST_TDSE_ID*/ AS iss_db,
15 
          si.dbid AS iss_id,
15 
          si.dbid AS iss_id,
16 
          si.job_number AS iss_num,
16 
          si.job_number AS iss_num,
17 
          si.problem_summary AS summary,
17 
          si.problem_summary AS summary,
18 
          sdef.name AS status,
18 
          sdef.name AS status,
19 
          si.priority AS priority,
 19 
          si.priority AS priority,
20 
          NULL AS issue_type
 20 
          NULL AS issue_type
21 
    FROM  TDSE_2002.admin.request si INNER JOIN TDSE_2002.admin.statedef sdef ON si.state = sdef.id
 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*/)
 22 
	WHERE  si.dbid IN (/*TDSEiss*/)
23 
	UNION ALL
 23 
	UNION ALL
24 
	SELECT  /*enumCLEARQUEST_VT5DM_ID*/ AS iss_db,
 24 
	SELECT  /*enumCLEARQUEST_VT5DM_ID*/ AS iss_db,
25 
		si.dbid AS iss_id,
25 
		si.dbid AS iss_id,
26 
		si.new_num AS iss_num,
26 
		si.new_num AS iss_num,
27 
	    si.headline AS summary,
27 
	    si.headline AS summary,
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  CQ_VT5DM.admin.software_issue si INNER JOIN CQ_VT5DM.admin.statedef sdef ON si.state = sdef.id
32 
	WHERE  si.dbid IN (/*VT5DMiss*/)
 32 
	WHERE  si.dbid IN (/*VT5DMiss*/)
33 
	UNION ALL
 33 
	UNION ALL
34 
	SELECT /*enumCLEARQUEST_VTSUP_ID*/ AS iss_db,
 34 
	SELECT /*enumCLEARQUEST_VTSUP_ID*/ AS iss_db,
35 
          si.dbid AS iss_id,
35 
          si.dbid AS iss_id,
36 
          si.job_number AS iss_num,
36 
          si.job_number AS iss_num,
37 
          si.problem_summary AS summary,
37 
          si.problem_summary AS summary,
38 
          sdef.name AS status,
38 
          sdef.name AS status,
39 
          si.priority AS priority,
 39 
          si.priority AS priority,
40 
          NULL AS issue_type
 40 
          NULL AS issue_type
41 
    FROM  VTSUP.admin.request si INNER JOIN VTSUP.admin.statedef sdef ON si.state = sdef.id
 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*/)
 42 
	WHERE  si.dbid IN (/*VTSUPiss*/)
43 
 
 43 
 
44 
	) AS issues
 44 
	) AS issues
45 
ORDER BY iss_num ASC
 - 
 
46 

            45
            
ORDER BY iss_num ASC

          

          

            -
            
 

            46