Aron's Tech Blog

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>

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>

The definitive upgrade protocol for TCC is spelled out in Doc ID 1907629.1, here’s the answer:

read more »

I’m always trying to make sense of TCC versions and found this article on MOS that addresses it SD6004 – TCC Version (Doc ID 1047569.1)

read more »

Another piece of documentation buried in the docs of a TCC installation.

As we know the [NOW] is a symbol that translates the current date and time as such:
The default date format is: NOW(“yyyyMMdd’T’HHmmss”) = 20080702T10:12:00

You can specify the time format by using any supported date and time pattern: NOW(“EEE, MMM d, yyyy”) = Wed, Jul 2, 2008

For more information on supported date and time patterns, please refer to: http:// java.sun.com/j2se/1.4.2/docs/api/java/text/SimpleDateFormat.html

This is strait out of the manual…

read more »

This is for new hire exports where you only want the most recent offer to be returned.  Remember to set the ownerQuery name.

<quer:filtering xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:equal>
<quer:field path="Offers"/>
<quer:query projectedClass="Offer" alias="My_Offer_Subquery">
<quer:projections>
<quer:projection alias="MaxOffer">
<quer:maximum>
<quer:field path="Offers,Number"/>
</quer:maximum>
</quer:projection>
</quer:projections>
<quer:filterings>
<quer:filtering>
<quer:equal>
<quer:field path="Application,Offers"/>
<quer:field ownerQuery="NewHire" path="Offers,Number"/>
</quer:equal>
</quer:filtering>
</quer:filterings>
</quer:query>
</quer:equal>
</quer:filtering>

You are correct, normally a record that is dropped from a net-change data file will result in it being deleted or de-activated in the zone by following net-change run.  However if there was a net-change setup run before the next ‘normal’ net-change than this wouldn’t happen.   This is because the net-change setup will delete the current net-change data repository and then re-populates it with zone values, but only for those records in the data file.  I’ve recently written an example for this scenario that may make this more clear.
read more »