Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Aged Reqs
Content
Plan is to count the no of aged reqs over 40days and then remove any req that has the following submision statuses Hire/Accepted,Awaiting....
I did this but it is still including those submissions. How can I do this?
FILTER(count(cast(case when (CASE WHEN DAYOFWEEK("Requisition First Sourcing Date"."Req. First Sourcing Date") > DAYOFWEEK(NOW()) THEN CASE WHEN DAYOFWEEK("Requisition First Sourcing Date"."Req. First Sourcing Date") = 7 THEN TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW()) - (Floor(TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW())/7)*2)-1 ELSE TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW()) - (Floor(TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW())/7)*2)-2 END ELSE TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW()) - (Floor(TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW())/7)*2) END-("Requisition Process Time"."Req. Total Days On Hold")*0.7143) > 39 then '1' end as integer)