Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Using Value Set for HCM groups — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Using Value Set for HCM groups

Received Response
edited Sep 29, 2020 5:42PM in Workforce Management 5 comments


Unable to Evaluate Value set criteria in HCM groups


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!