Using Value Set for HCM groups
Summary
Unable to Evaluate Value set criteria in HCM groupsContent
I created a Value Set (type = table) to read FULL_PART_TIME
I added the Value set= Include
When I refresh the group this criteria is not being evaluated and the log shows - "not in" and I expected it to say "in"
see sql log below
Criteria exp: [Assignment.GrpsEmploymentCategory] = 'PNB_07' OR [Assignment.GrpsEmploymentCategory] = 'PNB_05'
-------------------------------
select per.person_id, asg.assignment_id
, asg.employment_category
from per_all_people_f per , per_all_assignments_m asg
where :p_effective_date between per.effective_start_date and per.effective_end_date
Tagged:
0