Question
Identify Cases with No Assignments
Hi ,
How can we get the list of Cases that are not in resolved state , but do not have any assignments associated with it .
ex : say case is in broken process , and due to manual error the repair flow assignment is cancelled .
Thanks.
Accepted Solution
Hi Adithya
Ideally if there is an assignment associated , the case should have an entry in "pc_assign_worklist" or "pc_assign_workbasket" table. So what you can do is to write a query on Work table with a filter on Status is not resolved and have subquery to find the cases that exist in work table but not in "pc_assign_worklist" and "pc_assign_workbasket" table.
Hope it helps.
Regards
Bhavya
Hi Gayatri ,
No , not Broken Process , Once case goes to broken process , u can cancel that assignment from Other Actions , once the assignment is cancelled , case just stays in Pending-XXXXXXXXXX status without any assignments . How to pull a report all those cases in this state ? Below is the sample case
Accepted Solution
Hi Adithya
Ideally if there is an assignment associated , the case should have an entry in "pc_assign_worklist" or "pc_assign_workbasket" table. So what you can do is to write a query on Work table with a filter on Status is not resolved and have subquery to find the cases that exist in work table but not in "pc_assign_worklist" and "pc_assign_workbasket" table.
Hope it helps.
Regards
Bhavya