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.
Issue getting most recent/max date for "Offer Extended" Recruiting Event
Summary
I have an ORC report where I need to return only the most recent/latest date for a specific recruiting event (offer extended) but I am getting multiple rows returnedContent
Hello,
I have an OTBI analysis where I need to provide the most recent date when an ORC offer was extended to the candidate. In some cases, an offer may be extended and then reverted, reworked and re-extended, which creates multiple events of the type "OFFER_EXTENDED" in the database for the same job application. My challenge is that, applying a MAX on my CASE statement for this field does not limit the output to just the most recent date but rather returns NULL for the Date Offer Extended field for all records.
Tagged:
0