Question
Virtusa
US
Last activity: 6 Nov 2018 9:58 EST
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
Coforge DPA
GB
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
Virtusa
US
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
Pegasystems Inc.
IN
Did you try creating a Report Definition with filters for the pyStatusWork that displays the cases with some specific work status as per your requirement?
Pegasystems Inc.
IN
Regarding the open assignments, you can filter with ".pyOpenCount" property for a case type to display those cases with zero assignments.
CollabPartnerz
IN
Below link might help you
Accepted Solution
Coforge DPA
GB
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