Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
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.
TCC: Complex Filter - Max Date
Summary
Filter based on Max DateContent
Hi Community,
I have an export script that exports data from the Candidate Profile, the Offer and the Requisition all in 1 export script on the Candidate entity. I have 3 current filters on the export - two are string filters, and the third one is a complex projection that returns the latest offer (Max Offer Sequence) for the candidate.
My issue is that I am getting multiple rows for some candidates (they could be hired on different reqs over time - i.e. promotions etc). I already filter on the CSW Mnemonic to ensure only hires are considered,but out of the duplicate rows returned, how can I further filter to return only those where the Effective Start Date on the offer is the greatest of all the duplicates?
Tagged:
0