Subversion Repositories DevTools

Rev

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

Rev 3947 Rev 4554
Line 1... Line -...
1 
SELECT *
 - 
 
2 
  FROM
 - 
 
3 
       (
 - 
 
4 
 
 - 
 
5 
	   SELECT /*enumCLEARQUEST_DEVI_ID*/ AS iss_db,
 1 
SELECT /*enumCLEARQUEST_DEVI_ID*/ AS iss_db,
6 
	          si.dbid AS iss_id,
 2 
      si.dbid AS iss_id,
7 
			  si.new_num AS iss_num,
 3 
      si.new_num AS iss_num,
8 
			  si.headline AS summary,
 4 
      si.headline AS summary,
9 
			  sdef.name AS status,
 5 
      sdef.name AS status,
10 
			  si.priority AS priority,
 6 
      si.priority AS priority,
11 
			  si.releaseinfo as releaseinfo,
 7 
      dbms_lob.substr( si.releaseinfo, 4000, 1 )as releaseinfo,
12 
			  si.sbom as sbom,
 8 
      si.sbom as sbom,
13 
	          si.issue_type AS issue_type,
 9 
      si.issue_type AS issue_type,
14 
			  si.release_part1,
 10 
      si.release_part1,
15 
			  si.release_part2,
 11 
      si.release_part2,
16 
			  si.release_part3,
 12 
      si.release_part3,
17 
			  si.project,
 13 
      si.project,
18 
			  si.product,
 14 
      si.product,
19 
			  si.package_ref,
 15 
      si.package_ref,
20 
			  si.notes_log,
 16 
      dbms_lob.substr( si.notes_log, 4000, 1 ) AS notes_log,
21 
	          si.description,
 17 
      dbms_lob.substr( si.description, 4000, 1 )AS description,
22 
			  NULL AS release_id,
 18 
      NULL AS release_id,
23 
			  NULL AS client_ref,
 19 
      NULL AS client_ref,
24 
			  NULL AS severity,
 20 
      NULL AS severity,
25 
			  NULL AS cr_internal,
 21 
      NULL AS cr_internal,
26 
			  NULL AS cr_external,
 22 
      NULL AS cr_external,
27 
			  sp.fullname AS submitter,
 23 
      sp.fullname AS submitter,
28 
	          si.submit_date,
 24 
      si.submit_date,
29 
			  ow.fullname AS owner,
 25 
      ow.fullname AS owner,
30 
			  ap.fullname AS approver
 26 
      ap.fullname AS approver
31 
       FROM CQ_DEVI.admin.software_issue si INNER JOIN
 27 
FROM release_manager.CQ_software_issue si INNER JOIN
32 
            CQ_DEVI.admin.statedef sdef ON si.state = sdef.id INNER JOIN
 28 
     release_manager.CQ_statedef sdef ON si.state = sdef.id INNER JOIN
33 
            CQ_DEVI.admin.users sp ON si.submitter = sp.dbid INNER JOIN
 29 
     release_manager.CQ_users sp ON si.submitter = sp.dbid INNER JOIN
34 
            CQ_DEVI.admin.users ow ON si.owner = ow.dbid INNER JOIN
 30 
     release_manager.CQ_users ow ON si.owner = ow.dbid INNER JOIN
35 
            CQ_DEVI.admin.users ap ON si.approver = ap.dbid
 31 
     release_manager.CQ_users ap ON si.approver = ap.dbid
36 
		WHERE si.dbid IN (/*DEVIiss*/)
 32 
WHERE si.dbid IN (/*DEVIiss*/)
37 
 
 - 
 
38 
	) AS issues
 - 
 
39 
ORDER BY iss_num ASC
 33 
ORDER BY iss_num ASC