- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Aditya,
I will just query on channel equal to Email and status equal Sent.
Reason:
- primary key can not be null
- if email address contains , it will return a bounce with status failed
If your query is a frequent query and is taking long add db index on channel and status fields in the broadlog rcp schema.
<dbindex name="status">
<keyfield xpath="@status"/>
</dbindex>Thanks,
David
Views
Replies
0 Likes
Total Likes