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

General
, , , ,
1

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

2

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.

3

@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

4

@BhanuPrakash_G - Thanks.. it helped