Question

5
Replies
1582
Views
ManjunathaM8669 Member since 2016 15 posts
Societe Generale
Posted: 3 years ago
Last activity: 2 years 6 months ago
Closed
Solved

Fetching Latest Record for each category Using RD

Hi Team,

We have a requirement to fetch the latest record for each category. We have different mail boxes configured, emails received on those mail boxes will be stored in a database table. I have requirement to get the latest Email for each Mailbox. How can we achieve this. ?

I have tried by creating 2 reports.

1st Report : Added MailBox and created Date time columns.

Group by Mailbox and Max(ReceivedDateTime)

which gives me the latest record for each mailbox

2nd Report: Included all the columns which i want and then used a sub report which i created in last step. and the join condition i have given like the sub report and main report ReceivedDateTime and Mailbox should match.

This approach is working fine. But i want to know if there is any other better approach to achieve this.

***Updated by moderator: Lochan to add Categories***

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Case Management Reporting
Moderation Team has archived post
Share this page LinkedIn