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"&gt;
  <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"/>