Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Deeba Gurusamy (Deeba Guru)
CIBC

CIBC
CA
Deeba Guru Member since 2018 10 posts
CIBC
Posted: Jul 19, 2023
Last activity: Jul 20, 2023
Posted: 19 Jul 2023 14:56 EDT
Last activity: 20 Jul 2023 15:37 EDT
Closed
Solved

Fetch count of each case types start with "M-" or "W-" with Report Definition

How to fetch count of each case types form pyID ( Eg: case ID starts with "M-" or "W-" and count of each case type(Message case/Bulk case each counts) in Report Definition

***Edited by Moderator Marissa to change type from Pega Academy to Product; added Capability tags***
To see attachments, please log in.
Pega Smart Investigate for Payments 7.31
Reporting
Case Management
Financial Services
Senior System Architect

Posted: 1 year ago
Posted: 20 Jul 2023 3:49 EDT
Saurabh Gupta (SaurabhG7134)
ING Nederland
Pega Engineer
ING Nederland
NL

Hi @Deeba Guru, create 2 reports with count on pyID and filter condition as pyID starts with "M-" and "W-" respectively. Now, use these 2 reports as sub report to your main report and get the count.

To see attachments, please log in.

Accepted Solution

Posted: 1 year ago
Updated: 1 year ago
Posted: 20 Jul 2023 3:56 EDT
Updated: 20 Jul 2023 15:37 EDT
Bhanu Prakash G (BhanuPrakash_G)
JPMC
Associate
JPMC
IN

@Deeba Guru It would be easier if you can expose pyWorkIDPrefix property so that you can just have three columns in the Report Definition 

 pyWorkIDrefix

pyLabel

Count

To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice