Inserting Complex Queries

Before you start

Taleo Connect Client is running and ready for use.

An export editor based on the entity on which the complex queries will be applied is open.

This procedure applies to complex projections, complex filters, complex sorting, complex projection sorting, and all advanced tab functions.

Here's what to do

1. Click on Projections tab.
   1. Click on Add.
   2. Select Add a complex projection.
   3. Click on OK.

      The Complex projection pane displays: <quer:projection xmlns:quer="http://www.taleo.com/ws/integration/query"/>

2. Enter or paste code in Complex projection pane.

<quer:projection alias="Candidate_Anonymous" xmlns:quer="http://www.taleo.com/ws/integration/query">
  <quer:switchByValue>
    <quer:baseValue>
      <quer:field path="Candidate.Anonymous"/>
    </quer:baseValue>
    <quer:cases>
      <quer:case>
        <quer:integer>1</quer:integer>
        <quer:string>Anonymous candidate</quer:string>
      </quer:case>
      <quer:case>
        <quer:integer>0</quer:integer>
        <quer:string>Non anonymous candidate</quer:string>
      </quer:case>
    </quer:cases>
    <quer:defaultValue>
      <quer:string>Unknown</quer:string>
    </quer:defaultValue>
  </quer:switchByValue>
</quer:projection>