TCC: Complex Filter - Max Date

Summary

Filter based on Max Date

Content

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?