Subversion Repositories DevTools

Rev

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

Rev 1281 Rev 3973
Line 13... Line 13...
13 
        si.risk as risk,
 13 
        si.risk as risk,
14 
        si.related_database_patches as db_patches,
 14 
        si.related_database_patches as db_patches,
15 
        si.affected_packages as affected_packages
 15 
        si.affected_packages as affected_packages
16 
	FROM  CQ_DEVI.admin.software_issue si INNER JOIN CQ_DEVI.admin.statedef sdef ON si.state = sdef.id
 16 
	FROM  CQ_DEVI.admin.software_issue si INNER JOIN CQ_DEVI.admin.statedef sdef ON si.state = sdef.id
17 
	WHERE  si.dbid IN (/*DEVIiss*/)
 17 
	WHERE  si.dbid IN (/*DEVIiss*/)
18 
	UNION ALL
 - 
 
19 
	SELECT /*enumCLEARQUEST_TDSE_ID*/ AS iss_db,
 - 
 
20 
          si.dbid AS iss_id,
 - 
 
21 
          si.job_number AS iss_num,
 - 
 
22 
          si.problem_summary AS summary,
 - 
 
23 
          sdef.name AS status,
 - 
 
24 
          si.priority AS priority,
 - 
 
25 
          NULL AS issue_type,
 - 
 
26 
          NULL AS int_notes,
 - 
 
27 
          NULL AS cr_ref,
 - 
 
28 
          NULL AS risk,
 - 
 
29 
          NULL AS db_patches,
 - 
 
30 
          NULL AS affected_packages
 - 
 
31 
    FROM  CQ_TDSE.admin.request si INNER JOIN CQ_TDSE.admin.statedef sdef ON si.state = sdef.id
 - 
 
32 
	WHERE  si.dbid IN (/*TDSEiss*/)
 - 
 
33 
	UNION ALL
 - 
 
34 
	SELECT  /*enumCLEARQUEST_VT5DM_ID*/ AS iss_db,
 - 
 
35 
          si.dbid AS iss_id,
 - 
 
36 
          si.new_num AS iss_num,
 - 
 
37 
          si.headline AS summary,
 - 
 
38 
          sdef.name AS status,
 - 
 
39 
          si.priority AS priority,
 - 
 
40 
          si.issue_type AS issue_type,
 - 
 
41 
          NULL AS int_notes,
 - 
 
42 
          NULL AS cr_ref,
 - 
 
43 
          NULL AS risk,
 - 
 
44 
          NULL AS db_patches,
 - 
 
45 
          NULL AS affected_packages
 - 
 
46 
	FROM  CQ_VT5DM.admin.software_issue si INNER JOIN CQ_VT5DM.admin.statedef sdef ON si.state = sdef.id
 - 
 
47 
	WHERE  si.dbid IN (/*VT5DMiss*/)
 - 
 
48 
	UNION ALL
 - 
 
49 
	SELECT /*enumCLEARQUEST_VTSUP_ID*/ AS iss_db,
 - 
 
50 
          si.dbid AS iss_id,
 - 
 
51 
          si.job_number AS iss_num,
 - 
 
52 
          si.problem_summary AS summary,
 - 
 
53 
          sdef.name AS status,
 - 
 
54 
          si.priority AS priority,
 - 
 
55 
          NULL AS issue_type,
 - 
 
56 
          NULL AS int_notes,
 - 
 
57 
          NULL AS cr_ref,
 - 
 
58 
          NULL AS risk,
 - 
 
59 
          NULL AS db_patches,
 - 
 
60 
          NULL AS affected_packages
 - 
 
61 
    FROM  CQ_VTSUP.admin.request si INNER JOIN CQ_VTSUP.admin.statedef sdef ON si.state = sdef.id
 - 
 
62 
	WHERE  si.dbid IN (/*VTSUPiss*/)
 - 
 
63 
 
 - 
 
64 
	) AS issues
 18 
	) AS issues
65 
ORDER BY iss_num ASC
 19 
ORDER BY iss_num ASC