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.
Alerts Composer - SQL query
Summary:
We have a requirement where we are adding contract end date in the field of 'Projected End Date' for contingent workers.
In case where contract needs to be extended, the managers need to be alerted that the contract end date is reaching soon, and it needs to be extended.
And for the ones where we are absolutely sure about the contract end date, we are adding a Termination record for them on a future date.
So, how do we configure a filter in alert where we send notification/alert to the manager on the basis of Projected end date entered in the maximum assignment record with ACTIVE status ? I see that in the SQL, functions like MAX does not work, neither ORDER BY EFFECTIVE_END_DATE DESC works, nor subquery works.
Tagged:
0