Question
Tech Mahindra
AU
Last activity: 17 Feb 2020 23:19 EST
Report for retrieving the list of cases with no assignments
Hi Team,
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
Regards,
Subhajit
Pegasystems Inc.
FR
Hello,
Maybe system is not pulling any case because you still have an assignment for your broken cases. Like the OverAll SLA one?
Tech Mahindra
AU
Hi Bhavya,
Thanks for your reply
Did you write the first report in your CaseType class and modified the default pyGetWorklist report to return only the key?
What join conditions did you use while configuring the subreport?
One last question, 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
Regards,
Subhajit
Coforge DPA
GB
Hi
Answers below:
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.
Regards
Bhavya
Tech Mahindra
AU
Hi Bhavya,
I tried the approach but once I run the report, it is giving me 2 blank records which event don't have the pzInsKey.
I have referred the sub-report as you specified and have tried creating the report. It is not pulling the records.
Any further details will be highly appreciated. While joining the sub-report with the report did you select, only matching rows?
Regards,
Subhajit
Coforge DPA
GB
Hi
Below is the configuration for joining subreport:
You can also achieve the same scenario with just joins also. Give it a try.
If it is not working then share some screenshots.
Regards
Bhavya
Eclatprime Digital Private Limited
AU
Hi Subhajit,
You try with Join or Subreport. i have used join with Worklist and workbasket class and it is working. Below are the steps.
1) Create RD in Casetype class and add class join in data access tab as List- Assign-worklist and Basket - Assign-Workbasket using "include all rows in this class" and pzinskey as condition
2) add filters for join class any property value to is null. example : List.pxAssignedOperatorID "is null" and Basket.pxAssignedOperatorID "is null"
then it will pull the records which do not have assignment.