I have a requirement to implement a weekly email digest.
We have a custom table ABC that stores audit records whenever an Incident is created or updated. A separate record is created in the ABC table for each field update. The table contains the following information:
- Field Name
- Reference Record (Incident)
- Updated By
- Date/Time
- Old Value
- New Value
The Incident table contains a Category field (e.g., Network, Hardware).
Requirement:
- A weekly email digest should be sent every Friday.
- One email should be generated per Category.
- The email should contain all ABC records created during the week for incidents belonging to that category.
Example:
- For Network category, if 5 incidents are updated resulting in 35 records in the ABC table, a single email should be sent containing all 35 records.
- For Hardware category, if 2 incidents are updated resulting in 5 records in the ABC table, a separate email should be sent containing those 5 records.
Has anyone implemented a similar requirement using Email Digest? I am looking for guidance on how to group records by Category and send separate emails for each category. Any help would be greatly appreciated.
Thanks in advance.
