Hi ,

We have a requirement, we need to pull the data from the Work Table.

We need to get the count of records for each status(pyStatusWork) and we have conditions on each Status.

For Ex:

for the status "New" & "Resolved-Completed" we need to get the count of records that are created or closed on that day.

For the "Delayed","Pending" we need to get the record count till date.

Could you some one help me out on the approach.

We are using Pega PRPC 7.1.8.

Thanks & Regards,

Naveen