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.
OTBI - Field to show max effective_start_date by action_code
Summary
In OTBI workforce assignments I'd like to show the max effective_start_date of assignment based on action_codeContent
Hi all,
While working on "Workforce Management - Worker Assignment Event Real Time" subject area, alongside other fields I want to be able to filter out the latest effective_start_date for a specific person, based on action_code field.
I was trying to use the following but with no success:
filter(max("Assignment Event Details"."Effective Start Date") using "Assignment Event Details"."Action Code" = 'some_code').
Thanks in advance!
Pavel
Version
18.bCode Snippet
filter(max("Assignment Event Details"."Effective Start Date") using "Assignment Event Details"."Action Code" = 'some_code') 0