TCC: Complex Filter - Max Date
SummaryFilter based on Max Date
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?