Report for retrieving the list of cases with no assignments
I want to have a report that pulls up cases where the assignments have got removed due to some error and they are not resolved.
Here is the approach I have taken. I have created a report definition on the case type class and tried pulling the case IDs, created operator and few other fields. I have done a join on Assign-Worklist and Assign-WorkBasket classes by checking that our pzInsKey in our case type class in not present in both of those classes.
When we run the report, we see it is not pulling any cases where there are numerous cases that are present.
Any solution recommended will be highly appreciated
Did you write the first report in your CaseType class and modified the default pyGetWorklist report to return only the key? - Yes
What join conditions did you use while configuring the subreport? - Join on pzInsKey (Work Table) and pxRefObjectKey on WL/WB class
Do we need to do this for Workbasket as well or can we combine this logic anyways so that it gives us the list of all the cases which are in Worklist and workbasket - You might need to have separate subreport for that.