Assistance Needed: Value Set SQL Query (UNION Constraint)
Hi All,
I need some help adding a specific SQL query to a Value Set. The main thing is, I can only use UNION
to get the data I need.
Please note, the FROM
clause has a 200-character limit.If you've worked on similar requirements, any guidance would be greatly appreciated.
Query :-
Select EMP.DISPLAY_VALUEFROM (SELECT pj.JOB_CODE || ' - ' || pj.NAME || ' - ' || ppnf.display_name AS DISPLAY_VALUE, pj.JOB_ID AS RETURN_VALUE -- Assuming you need a return value, e.g., JOB_IDFROM PER_JOBS_F_VL pj, per_person_names_f ppnf, per_all_assignments_f paaf, HR_ORGANIZATION_UNITS BU_UNITWHERE PJ.ACTIVE_STATUS = 'A' AND PJ.ATTRIBUTE2 = 'Y' -- This is the key filter on Job Page AND pj.job_id = paaf.job_id AND paaf.assignment_type = 'E' AND paaf.assignment_status_type = 'ACTIVE' AND ppnf.person_id = paaf.person_id AND ppnf.name_type = 'GLOBAL' AND BU_UNIT.ORGANIZATION_ID = paaf.BUSINESS_UNIT_ID AND BU_UNIT.NAME = '****' AND TRUNC(paaf.effective_end_date)