AnsweredAssumed Answered

report not finished overdue approvals/activities

Question asked by Zoltan Izsak on Nov 7, 2019
Latest reply on Nov 14, 2019 by Zoltan Izsak

Due to SLA checking reasons I would like to report those ongoing approvals and activities which are overdue. So far I have found a (bit buggy) template which reports finished overdue approvals/activities. Also I have found the t_av_work_item_metrics table with overdue_time_value column but its value is null until the workitem is finished. Probably I can make some joins and process the current_time - open_time_value for all available CR items but still hope that there is an easier way.

Outcomes