I have a requirement to identify the application process quality check based on the actions performed by level 1 and level 2 people.
level1 as (Reviewer), Level 2 as (Approver)
Lets say an application sent to level 1 user for approval he should review and approve it, next it will go to level 2 user for final approval.
Here we need to show list of applications are sent back for modification from level 2 to level 1 and again level 1 will modify it and send for final approval to level 2.
As mentioned in the below table these entries are for one application.
L1 Review & Sent for Approval > L2 Reviewed & suggested for Modification
L1 Modified > >> L2 Approved
* Need to be display such kind of apps . In below table twice this app was sent back for modifications also need to consider if L2 person sent for modification once instead of twice.
|16-04-2021||31120312356||u986||Reviewer L1||Modify|| |
|16-04-2021||31120312356||u986||Reviewer L1||Approve|| |
|17-04-2021||31120312356||u124||Approver L2||Modify|| |
|18-04-2021||31120312356||u986||Reviewer L1||Modify|| |
|18-04-2021||31120312356||u986||Reviewer L1||Approve|| |
|19-04-2021||31120312356||u158||Approver L2||Modify|| |
|19-04-2021||31120312356||u986||Reviewer L1||Modify|| |
|20-04-2021||31120312356||u986||Reviewer L1||Approve|| |
|20-04-2021||31120312356||u158||Approver L2||Approve|| |