Monthly Archives: February 2019

TCC

TCC – Requisition Approved Date

Ran across a need to pull the approved date (latest) from a requisition export and it seems like something I could run across again so here it is:

<quer:projection alias="Recruiting_Start_Date" xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:query projectedclass="Requisition" alias="sqLocation" preventduplicates="true" pagingsize="1">
<quer:projections>
<quer:projection alias="ApproveDate" projectedvaluetype="string">
<quer:customfunction name="TO_CHAR">
<quer:field path="RequisitionEvent,EventDate">
<quer:string>yyyy-MM-dd</quer:string>
</quer:field></quer:customfunction>
</quer:projection>
</quer:projections>
<quer:filterings>
<quer:filtering>
<quer:equal>
<quer:field path="Number">
<quer:field ownerquery="MainQuery" path="Number">
</quer:field></quer:field></quer:equal>
</quer:filtering>
<quer:filtering>
<quer:equal>
<quer:field path="RequisitionEvent,WorkActionNumber">
<quer:string>12</quer:string>
</quer:field></quer:equal>
</quer:filtering>
<quer:filtering>
<quer:equal>
<quer:field path="RequisitionEvent,EventDate">
<quer:query projectedclass="Requisition" alias="sqMotives" preventduplicates="true" pagingsize="1">
<quer:subqueries>
<quer:projections>
<quer:projection>
<quer:maximum>
<quer:field path="RequisitionEvent,EventDate">
</quer:field></quer:maximum>
</quer:projection>
</quer:projections>
<quer:filterings>
<quer:filtering>
<quer:equal>
<quer:field path="Number">
<quer:field ownerquery="MainQuery" path="Number">
</quer:field></quer:field></quer:equal>
</quer:filtering>
<quer:filtering>
<quer:equal>
<quer:field path="RequisitionEvent,WorkActionNumber">
<quer:string>12</quer:string>
</quer:field></quer:equal>
</quer:filtering>
</quer:filterings>
</quer:subqueries></quer:query>
</quer:field></quer:equal>
</quer:filtering>
</quer:filterings>
</quer:query>
</quer:projection>