Hi @RaviY230: Can you get the SQL generated and run it in the DB to see if there is a logic issue because of which the values are not available in the report?

Thanks.

@RaviY230 do you have a screenshot of your rep def setup?

Hi @RaviY230

There could be several reasons why your report definition is not fetching newly resolved cases in Pega. Here are a few things you can check:

Filter Criteria: Check the filter criteria of your report definition. Make sure it’s set up to include newly resolved cases. If there’s a date or time condition, ensure it does not exclude recent cases.

Database Synchronization: There might be a delay in the database synchronization. If the cases were resolved very recently, they might not have been updated in the database at the time the report was run.

Access Group Settings: Check your access group settings. Make sure that the access group associated with your operator ID has the necessary permissions to view the newly resolved cases.

Tracer and DB Query: If the report definition is not able to fetch as expected, run the tracer and enable the DB query to capture the query being formed. If you have DB access then you can run the query at the DB end to verify the query formation.