We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

TCC - Exporting latest attachment per candidate

Accepted answer
39
Views
2
Comments
edited Jun 13, 2016 9:04AM in Taleo Enterprise Integrations 2 comments

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"/>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!