Apex Code Development You need to sign in to do that
Don't have an account?
Arbab Hassan How can I also filter based on the date the email was sent to the subscriber?
Currently, we query for OpenEvents using a filter on the EventDate. How can I also filter based on the date the email was sent to the subscriber? For example, I want to query for OpenEvents from within the past week, but exclude any for emails that were sent over a month ago.
I do see a risk with filtering the records based on email sent date, you may probably have events where there are no emails sent at all.
I would query last week open events and then loop through all the records to filter events for which email has been sent in last 30 days.
Lokesh