TCC – Max Offer Filter for New Hire

This complex filter ensures that you are pulling the most recent offer information with the new hire.

<quer:filtering xmlns:quer="http://www.taleo.com/ws/integration/query">
 <quer:equal>
 <quer:field path="Offers"/>
 <quer:query projectedClass="Offer" alias="My_Offer_Subquery">
 <quer:projections>
 <quer:projection alias="MaxOffer">
 <quer:maximum>
 <quer:field path="Offers,Number"/>
 </quer:maximum>
 </quer:projection>
 </quer:projections>
 <quer:filterings>
 <quer:filtering>
 <quer:equal>
 <quer:field path="Application,Offers"/>
 <quer:field ownerQuery="NewHire" path="Offers,Number"/>
 </quer:equal>
 </quer:filtering>
 </quer:filterings>
 </quer:query>
 </quer:equal>
</quer:filtering>