Compliance report
Summary
Trying to filter report to show personnel areaContent
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'