Subversion Repositories DevTools

		UNION ALL

	   SELECT /*enumCLEARQUEST_TDSE_ID*/ AS iss_db,

	   		  si.dbid AS iss_id,

			  si.job_number AS iss_num,

			  si.problem_summary AS summary,

			  sdef.name AS status,

			  si.priority AS priority,

			  NULL AS releaseinfo,

			  NULL AS sbom,

			  NULL AS issue_type,

			  NULL AS release_part1,

			  NULL AS release_part2,

			  NULL AS release_part3,

			  si.group_project AS project,

	          si.category_main AS product,

			  NULL AS package_ref,

			  si.notes_log,

			  si.description,

			  si.release_id,

			  si.client_ref,

			  si.severity,

	          si.change_request AS cr_internal,

			  si.external_change_request AS cr_external,

			  sp.fullname AS submitter,

			  si.when_reported AS submit_date,

	          ow.fullname AS owner,

			  ap.fullname AS approver

     FROM CQ_TDSE.admin.request si INNER JOIN

            CQ_TDSE.admin.statedef sdef ON si.state = sdef.id INNER JOIN

            CQ_TDSE.admin.users ow ON si.owner = ow.dbid INNER JOIN

            CQ_TDSE.admin.users sp ON si.raised_by = sp.dbid INNER JOIN

            CQ_TDSE.admin.users ap ON si.who_reported = ap.dbid

		WHERE si.dbid IN (/*TDSEiss*/)