For more information, please refer to this announcement explaining best practices for getting answers to questions.
TCC - Exporting latest attachment per candidate
Content
Hello,
I am trying to export list of attachments added by candidate but am only interested in most recently modified attachment.
I have the following complex filter added to my export that is run from Candidate entity:
<quer:filtering xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:or>
<quer:equal>
<quer:field path="AttachedFiles,LastModificationDate"/>
<quer:query projectedClass="Candidate" alias="histItemSubQuery">
<quer:projections>
<quer:projection>
<quer:maximum>
<quer:field path="AttachedFiles,LastModificationDate"/>
</quer:maximum>
</quer:projection>
</quer:projections>
<quer:filterings>
<quer:filtering>
<quer:equal>
<quer:field ownerQuery="histItemSubQuery" path="Number"/>
<quer:field ownerQuery="Candidate" path="Number"/>