Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Latest Assignment Change
Content
Hello,
I'm trying to pull the latest assignment change row using the Assignment Event Subject area, but it doesn't seem to be working anymore. In the past I've used (RCOUNT("Assignment Event Details"."Effective Start Date") IN (RMAX(RCOUNT("Assignment Event Details"."Effective Start Date")))) with a group by function on "Worker"."Person Number".
I'm wondering if anyone else has anyway to pull the latest assignment row without the Logical SQL Query?
Version
20C0