Infolet Report Failing / Erroring with Direct and Indirect Reporting Line
Hi all, I'm hoping someone can tell me if what I'm trying to achieve here is possible.
The report itself should look at anyone who has learning that's due and then apply the case statement to it to return who's is currently overdue.
I've built an OTBI report (I can attach the catalog file if needed / possible) that does the following:
The case when statement looks like this:
CASE WHEN "Assignment Status"."Name" = 'Active' AND CAST("Learning Record Details"."Due Date" AS TIMESTAMP) < CAST(CURRENT_DATE AS TIMESTAMP) THEN 'Overdue'
WHEN "Assignment Status"."Name" = 'Active' AND CAST("Learning Record Details"."Due Date" AS TIMESTAMP) >= CAST(CURRENT_DATE AS TIMESTAMP) THEN 'Outstanding'
WHEN "Assignment Status"."Name" = 'Completed' AND CAST("Learning Record Details"."Completion Date" AS TIMESTAMP) > CAST("Learning Record Details"."Due Date" AS TIMESTAMP) THEN 'Completed (Past Due Date)'
WHEN "Assignment Status"."Name" = 'Active' THEN 'Active (No Due Date)'
WHEN "Assignment Status"."Name" = 'Completed' THEN 'Completed' ELSE 'No Criteria Matches'
END
Tagged:
0