- Thu Aug 06, 2020 5:23 am
#828286
I have to support reports in processmaker 3.4. A supervisor or admin can define certain SLA's. According to those SLA's i have to identify the performance of any given user ( or all users ).
My goal is :
1. Find out process completion time in days/minutes.
2. Find out task completion time in days minutes.
3. Number of process instances that were completed within the SLA
Number of process instances that were NOT completed within the SLA
4. Number of process instances that were completed within the Due date/time
Number of process instances that were NOT completed within the Due date/time
I also want to filter these results based on DATE RANGE (week, day, month, custom range) , ASSIGNEE, OWNER.
Any help would be highly appreciated.
NOTE : i don't want to use any plugin or third party tool. I need to do it via mysql queries.
Thank you.
My goal is :
1. Find out process completion time in days/minutes.
2. Find out task completion time in days minutes.
3. Number of process instances that were completed within the SLA
Number of process instances that were NOT completed within the SLA
4. Number of process instances that were completed within the Due date/time
Number of process instances that were NOT completed within the Due date/time
I also want to filter these results based on DATE RANGE (week, day, month, custom range) , ASSIGNEE, OWNER.
Any help would be highly appreciated.
NOTE : i don't want to use any plugin or third party tool. I need to do it via mysql queries.
Thank you.