Question
1
Replies
2261
Views
TCS
Posted: 3 years ago
Last activity: 3 years 2 months ago
Report definition for count subcases for different status
We have requirement where Parent case has multiple child cases different case types (Work Types).
And we have to create a report where we have to show data as well as the count of subcases which has status
"Open" , "Resolved", "Closed" and "With drawn"
For EG : Status
Parent Case : LIQ-1
Child Case : DM-1 (Resolved-Completed)
DV-1 (Cancelled)
BOOK-1(Resolved-Completed)
SV-1(Resolved-Withdrawn)
FUND-1 (Resolved-Completed)
FUND-2 (Resolved-Completed)
I need the count of this differnt subcases on the basis of their status.
How to achieve this ?
***Edited by Moderator Marissa to update categories***
Accepted Solution
Posted: 3 years ago
Hi,
There are many ways to do this:
1. In the parent case you will find pxCoveredCount which holds the total no. of child cases for the case and pxCoveredCountOpen which holds the total no. of child cases that are not resolved. But with these properties you can only get count of resolved and open cases not the count of each open status or each resolved status
2. If you want a report for each open and resolve statuses then you need to report on child cases. In the child case pxCoverInsKey holds the pzInsKey of the parent case. So can group by using pxCoverInsKey and pyStatusWork to get the desired output. If different child cases are stored on different tables then you might need to join them using pxCoverInsKey and then report on the result set. Consider creating database view also depending upon the data structure.
Hope this helps!
Regards,
Gourav