TCC – Static Level Decode
This is for when you’re trying to list out location1, location2, etc…
Much easier to build as a complex projection but then the GUI converts it so you have to start from scratch to change.
<quer:projection alias="LocationLevel1" xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:decode>
<quer:field path="JobInformation,PrimaryLocation,Level"/>
<quer:string>1</quer:string>
<quer:field path="JobInformation,PrimaryLocation,Name"/>
<quer:string>2</quer:string>
<quer:field path="JobInformation,PrimaryLocation,Parent,Name"/>
<quer:string>3</quer:string>
<quer:field path="JobInformation,PrimaryLocation,Parent,Parent,Name"/>
<quer:string>4</quer:string>
<quer:field path="JobInformation,PrimaryLocation,Parent,Parent,Parent,Name"/>
<quer:string>5</quer:string>
<quer:field path="JobInformation,PrimaryLocation,Parent,Parent,Parent,Parent,Name"/>
</quer:decode>
</quer:projection>
<quer:projection alias="LocationLevel2" xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:decode>
<quer:field path="JobInformation,PrimaryLocation,Level"/>
<quer:string>1</quer:string>
<quer:string/>
<quer:string>2</quer:string>
<quer:field path="JobInformation,PrimaryLocation,Name"/>
<quer:string>3</quer:string>
<quer:field path="JobInformation,PrimaryLocation,Parent,Name"/>
<quer:string>4</quer:string>
<quer:field path="JobInformation,PrimaryLocation,Parent,Parent,Name"/>
<quer:string>5</quer:string>
<quer:field path="JobInformation,PrimaryLocation,Parent,Parent,Parent,Name"/>
</quer:decode>
</quer:projection>
<quer:projection alias="LocationLevel3" xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:decode>
<quer:field path="JobInformation,PrimaryLocation,Level"/>
<quer:string>1</quer:string>
<quer:string/>
<quer:string>2</quer:string>
<quer:string/>
<quer:string>3</quer:string>
<quer:field path="JobInformation,PrimaryLocation,Name"/>
<quer:string>4</quer:string>
<quer:field path="JobInformation,PrimaryLocation,Parent,Name"/>
<quer:string>5</quer:string>
<quer:field path="JobInformation,PrimaryLocation,Parent,Parent,Name"/>
</quer:decode>
</quer:projection>
<quer:projection alias="LocationLevel4" xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:decode>
<quer:field path="JobInformation,PrimaryLocation,Level"/>
<quer:string>1</quer:string>
<quer:string/>
<quer:string>2</quer:string>
<quer:string/>
<quer:string>3</quer:string>
<quer:string/>
<quer:string>4</quer:string>
<quer:field path="JobInformation,PrimaryLocation,Name"/>
<quer:string>5</quer:string>
<quer:field path="JobInformation,PrimaryLocation,Parent,Name"/>
</quer:decode>
</quer:projection>