you need to review RD definition to see what it is supposed to do.

Hopefully, you will get something there.

Hi,

Check the RD and the filter criteria first. I think you are running the RD individually to see the rows fetched. If RD is  not able to fetch the expected run the tracer and enable DB query to capture the query being formed. If you have DB access the you can run the query at DB end to verify the query formation. But mostly check your filter criteria.

Thank You

Attach the screenshot of the RD you are using...

Is there any filter condition applied?

Does your RD retrieves the cases without any filter?

Modified filter criteria, working as expected

Thank you