Archives: February 20, 2015

I can’t believe I jacked with this process for a stinking hour before I stumbled on the the right combination. Use the below XML to create the _ld.xml file.

<?xml version="1.0" encoding="UTF-8"?>
<load:load productCode="RC1401" model="http://www.taleo.com/ws/tee800/2009/01" root="UDSElement" operation="delete" locale="en" header="true" delimiter="," quote="&quot;" xmlns:load="http://www.taleo.com/ws/integration/load">
    <load:columns>
        <load:column parameter="1" type="DATA" path="UserDefinedSelection,Code" searchType="SEARCH" searchTarget=".." localeType="NONE"/>
        <load:column parameter="1" type="DATA" path="Code" searchType="SEARCH" searchTarget="." localeType="NONE"/>
    </load:columns>
    <load:processingInstructions/>
</load:load>

Not sure why the diversity questions are nested the way they are as opposed to the questions. Diversity questions are the canned questions related to EEO, if the client is using those you have to get the answer from the diversity questions element. Here is a sample of how it works:

<quer:projection id="idEEO2OtherProtectVetAnswerNo" alias="OtherProtectedVetAnswer" xmlns:quer="http://www.taleo.com/ws/integration/query">
  <quer:query projectedClass="Candidate" alias="CandOtherProtectVetNo">
    <quer:projections>
      <quer:projection alias="EEO2OtherProtectVetNo">
        <quer:decode>
          <quer:field path="DiversityAnswers,PossibleAnswer,PossibleAnswerType,Number"/>
          <quer:integer>291</quer:integer>
          <quer:string>Y</quer:string>
          <quer:integer>292</quer:integer>
          <quer:string>N</quer:string>
          <quer:integer>2</quer:integer>
          <quer:string>X</quer:string>
          <quer:integer>1</quer:integer>
          <quer:string>NS</quer:string>
        </quer:decode>
      </quer:projection>
    </quer:projections>
    <quer:filterings>
      <quer:filtering>
        <quer:equal>
          <quer:field path="DiversityAnswers,Question,Number"/>
          <quer:integer>12232093</quer:integer>
        </quer:equal>
      </quer:filtering>
      <quer:filtering>
        <quer:equal>
          <quer:field path="Number"/>
          <quer:field ownerQuery="NewHire" path="Candidate"/>
        </quer:equal>
      </quer:filtering>
    </quer:filterings>
  </quer:query>
</quer:projection>

When you are looking to return the value of a disqualification question in TCC the below code will work.  This is out of transitions.

<quer:projection id="idAuthToWorkUS" alias="UWH_LEGALLY_AUTH" xmlns:quer="http://www.taleo.com/ws/integration/query">
  <quer:query projectedClass="Candidate" alias="AuthToWork">
    <quer:projections>
      <quer:projection alias="idAuth_To_Work_US">
        <quer:field path="ProfileInformation,Candidate,QuestionAnswers,Answer,Description"/>
      </quer:projection>
    </quer:projections>
    <quer:filterings>
      <quer:filtering>
        <quer:equal>
          <quer:field path="ProfileInformation,Candidate,QuestionAnswers,Question"/>
          <quer:string>5053</quer:string>
        </quer:equal>
      </quer:filtering>
      <quer:filtering>
        <quer:equal>
          <quer:field path="Number"/>
          <quer:field ownerQuery="MainQuery" path="ProfileInformation,Candidate"/>
        </quer:equal>
      </quer:filtering>
    </quer:filterings>
  </quer:query>
</quer:projection>