Aron's Tech Blog

Transitions is easy to export out of because of the fact you build every filed that you need.  Unfortunately you sometimes have to dig it out of the candidate data if it’s a question they answered. Here is the code to do just that.

<quer:projection id="idReturnField" alias="Header_Alias" xmlns:quer="http://www.taleo.com/ws/integration/query">
  <quer:query projectedClass="TransitionProcess" alias="Transition_Item_Id">
    <quer:projections>
      <quer:projection alias="Transition_Item_Id">
        <quer:decode>
          <quer:field path="ProfileInformation,Candidate,QuestionAnswers,Answer,Number"/>
          <quer:string>[AnsNo]</quer:string>
          <quer:string>YES</quer:string>
          <quer:string>[AnsNo]</quer:string>
          <quer:string>NO</quer:string>
          <quer:string>NA</quer:string>
        </quer:decode>
      </quer:projection>
    </quer:projections>
    <quer:filterings>
      <quer:filtering>
        <quer:equal>
          <quer:field path="ProfileInformation,Candidate,QuestionAnswers,Question,Code"/>
          <quer:string>[QuesCode]</quer:string>
        </quer:equal>
      </quer:filtering>
      <quer:filtering>
        <quer:equal>
          <quer:field path="Number"/>
          <quer:field ownerQuery="MainQuery" path="Number"/>
        </quer:equal>
      </quer:filtering>
    </quer:filterings>
  </quer:query>
</quer:projection>