Archives: March 26, 2015

So digging through the full export of questions I had to consult the data dictionary and was pleasantly surprised that I came upon a new to me table called TypeOfQuestion. If you filter on the value in this table from your export, you can just return the type of questions that you are looking for. Here are the look up values:

Every time that I run across the diversity answer export it gives me trouble. So I suppose it’s time to document it. To find the variables do an export on DiverstityAnswers targeting the Question and PossibleAnswer related tables. You can then sub them into this projection:

<quer:projection id="idGender" alias="USAEEO2Gender" xmlns:quer="http://www.taleo.com/ws/integration/query">
  <quer:query projectedClass="Candidate" alias="EEO2b_Gender">
    <quer:projections>
      <quer:projection alias="EEO2b_Gender">
        <quer:decode>
          <quer:field path="DiversityAnswers,PossibleAnswer,Sequence"/>
          <quer:integer>2</quer:integer>
          <quer:string>M</quer:string>
          <quer:integer>3</quer:integer>
          <quer:string>F</quer:string>
          <quer:integer>4</quer:integer>
          <quer:string>U</quer:string>
        </quer:decode>
      </quer:projection>
    </quer:projections>
    <quer:filterings>
      <quer:filtering>
        <quer:equal>
          <quer:field path="DiversityAnswers,Question,Code"/>
          <quer:string>EEO2b Gender</quer:string>
        </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>

So I’ve got an issue with TCC that honestly has me thinking about a new career path. I’m using the touchpoints and it won’t let me extract anything from the offer. I’ll let you know the outcome of that but there is a debugging command you can use in the advanced export options:
Name = debug.log.sql.queries
Value = true

Uncheck the delete temporary files on completion in the config and when you run the integration, in the runtime monitoring it will hyperlink the steps to the files. Pretty cool stuff.

Sometimes you are building an integration that you know is going to return a kajillion rows, you see this in things like the questionAnswer exports and such. I had someone tell me there was a way to set an advanced setting to make it only return so many rows and indeed the page size points to that but as with most things, use the code for it…

<quer:filtering xmlns:quer="http://www.taleo.com/ws/integration/query">
  <quer:lessThanOrEqual>
    <quer:customValue>
      <quer:expression>rowNum</quer:expression>
    </quer:customValue>
    <quer:integer>10</quer:integer>
  </quer:lessThanOrEqual>
</quer:filtering>