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:customFunction>
</quer:projection>
</quer:projections>
<quer:filterings>
<quer:filtering>
<quer:equal>
<quer:field path="Number"/>
<quer:field ownerQuery="MainQuery" path="Number"/>
</quer:equal>
</quer:filtering>
<quer:filtering>
<quer:equal>
<quer:field path="RequisitionEvent,WorkActionNumber"/>
<quer:string>12</quer:string>
</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:maximum>
</quer:projection>
</quer:projections>
<quer:filterings>
<quer:filtering>
<quer:equal>
<quer:field path="Number"/>
<quer:field ownerQuery="MainQuery" path="Number"/>
</quer:equal>
</quer:filtering>
<quer:filtering>
<quer:equal>
<quer:field path="RequisitionEvent,WorkActionNumber"/>
<quer:string>12</quer:string>
</quer:equal>
</quer:filtering>
</quer:filterings>
</quer:query>
</quer:equal>
</quer:filtering>
</quer:filterings>
</quer:query>
</quer:projection>