We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Compliance report

Received Response
34
Views
1
Comments
edited Dec 8, 2016 12:18AM in Reporting and Analytics Taleo Enterprise 1 comment

Summary

Trying to filter report to show personnel area

Content

Creating a compliance report from BO to OBI that is using a subquery.  Need to use the Req Identifier to write SQL in order to see all candidate counts for the requisitions.  Works until I add in the Personnel area and no matter how I write the SQL I do not get the data expected

I have uploaded a screenshot of the current filter and below is the last SQL that I tried.

SELECT "Requisition Identification"."Req. Identifier" FROM "Recruiting" WHERE "Submission Dates"."Offer Actual Start Date" BETWEEN @{From_Date}{'01/01/2016'} AND @{To_Date}{'02/01/2016'} AND "Submission General Info"."Submission Is Completed"='Yes' AND "Submission CSW Status - Current"."Current Status Name"='Hired' AND "Submission General Info"."Submission Is Internal"='No' AND "Candidate Identification"."Candidate Is Internal"='No'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!