Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
How do I report on only the most recent assignment (active or terminated)?
Summary
I need to build a report of all employees and only want the most recent assignment to appear on my report.Content
Hi all,
Does anyone know how to report on all the most recent assignment? I tried using MAX to filter on assignment number, but feel like I'm definitely doing this incorrectly:
Assignment Number is equal to MAX("Workforce Management - Worker Assignment Real Time"."Worker Assignment Details"."Assignment Number")
Example: employee John Doe has 3 assignments in HCM (two active 800, 800-1, then one inactive 800-2). I only want the most recent assignment (800-2) to appear on my report.
1