Avatar

Correct answer by
Community Advisor

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

 

View solution in original post