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.
Assignment Changes L-SQL Query Issue
Hi all,
I've been using and adapting Julian's L-SQL query posted here:
to try and return previous roles for employees.
It all works great until we have someone who has two assignment changes in one change, see screenshot below:
This individual does not show on the report at all.
Does anyone have any ideas on how we can show employees with more than one Assignment Change in one change, so to speak?
Attached is the L-SQL I'm using.
Thanks!
Tagged:
0