Subversion Repositories DevTools

Rev

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

Rev 1281 Rev 3973
Line 31... Line 31...
31 
            CQ_DEVI.admin.statedef sdef ON si.state = sdef.id INNER JOIN
 31 
            CQ_DEVI.admin.statedef sdef ON si.state = sdef.id INNER JOIN
32 
            CQ_DEVI.admin.users sp ON si.submitter = sp.dbid INNER JOIN
 32 
            CQ_DEVI.admin.users sp ON si.submitter = sp.dbid INNER JOIN
33 
            CQ_DEVI.admin.users ow ON si.owner = ow.dbid INNER JOIN
 33 
            CQ_DEVI.admin.users ow ON si.owner = ow.dbid INNER JOIN
34 
            CQ_DEVI.admin.users ap ON si.approver = ap.dbid
 34 
            CQ_DEVI.admin.users ap ON si.approver = ap.dbid
35 
		WHERE si.dbid IN (/*DEVIiss*/)
 35 
		WHERE si.dbid IN (/*DEVIiss*/)
36 
 
 - 
 
37 
		UNION ALL
 - 
 
38 
 
 - 
 
39 
	   SELECT /*enumCLEARQUEST_TDSE_ID*/ AS iss_db,
 - 
 
40 
	   		  si.dbid AS iss_id,
 - 
 
41 
			  si.job_number AS iss_num,
 - 
 
42 
			  si.problem_summary AS summary,
 - 
 
43 
			  sdef.name AS status,
 - 
 
44 
			  si.priority AS priority,
 - 
 
45 
			  NULL AS releaseinfo,
 - 
 
46 
			  NULL AS issue_type,
 - 
 
47 
			  NULL AS release_part1,
 - 
 
48 
			  NULL AS release_part2,
 - 
 
49 
			  NULL AS release_part3,
 - 
 
50 
			  si.group_project AS project,
 - 
 
51 
	          si.category_main AS product,
 - 
 
52 
			  NULL AS package_ref,
 - 
 
53 
			  si.notes_log,
 - 
 
54 
			  si.description,
 - 
 
55 
			  si.release_id,
 - 
 
56 
			  si.client_ref,
 - 
 
57 
			  si.severity,
 - 
 
58 
	          si.change_request AS cr_internal,
 - 
 
59 
			  si.external_change_request AS cr_external,
 - 
 
60 
			  sp.fullname AS submitter,
 - 
 
61 
			  si.when_reported AS submit_date,
 - 
 
62 
	          ow.fullname AS owner,
 - 
 
63 
			  ap.fullname AS approver
 - 
 
64 
     FROM CQ_TDSE.admin.request si INNER JOIN
 - 
 
65 
            CQ_TDSE.admin.statedef sdef ON si.state = sdef.id INNER JOIN
 - 
 
66 
            CQ_TDSE.admin.users ow ON si.owner = ow.dbid INNER JOIN
 - 
 
67 
            CQ_TDSE.admin.users sp ON si.raised_by = sp.dbid INNER JOIN
 - 
 
68 
            CQ_TDSE.admin.users ap ON si.who_reported = ap.dbid
 - 
 
69 
		WHERE si.dbid IN (/*TDSEiss*/)
 - 
 
70 
 
 - 
 
71 
 
 - 
 
72 
	) AS issues
 36 
	) AS issues
73 
ORDER BY iss_num ASC
 37 
ORDER BY iss_num ASC