Subversion Repositories DevTools

Rev

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

Rev 1281 Rev 3973
Line 8... Line 8...
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
 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
 - 
 
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
 13 
	) AS issues
45 
ORDER BY iss_num ASC
 14 
ORDER BY iss_num ASC
46 

            15