The request was made to be able to filter out people who received a specific mailing. The views_mail_scheduled log table contains the e-mails sent, but I have so far been unable to figure out a way to link those e-mail addresses to the source e-mail addresses in the source node (the node you used in your view to create the mailing list in the first place)

So, I figured the best way to handle this was to add another field to the views_mail_scheduled table: recipient_nid. This is the node id of the node from which the recipient_email is derived (if, in fact, it is taken from a node).

So, if you wish to create a view that contains both the source node for your e-mails, and the views_mail_scheduled log of e-mails sent, then you will need to:

a. Include a "node id" field in your view. This will be the node id of the record which contains the e-mail you are selecting for the view.

b. Select this node id field when you "Configure" your Views Mail mailing.

When you do the above, the node id for each e-mail address will be recorded into the views_mail_scheduled log table when the mailing is processed. This will allow you to create a view that can be "filtered" by both the views_mail and views_mail_scheduled log fields.

If your e-mail addresses are not coming from a node, then select "none" for the "node id" field in the "Configure mailing" step.

The code changes for this update will be submitted to CVS shortly, and available for download in the dev release. Please note that you when you install this latest update, you will also need to run "update.php" as the views_mail_scheduled table has been modified.

Comments

somebodysysop’s picture

somebodysysop commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

patchak’s picture

patchak commented
Status: Closed (fixed) » Active

Hey there, I just tested this, but I'm wondering how I can then filter that same view to see who received a specific mail? I'ts not clear for me what is the column I need to add to filter on ??

Thanks,
Patchak

patchak’s picture

patchak commented
Status: Active » Closed (fixed)

Hummm ok I found out some filters to filter by the Subject line of the Views Mail. That's perfect for my needs, closing.

somebodysysop’s picture

somebodysysop commented

If you are using the latest dev release, there is also an option when you configure the mailing to select the "node id". If you select this, the node id for each email is stored in the views mail schedule log for each email. This means that you can create a view whose records contain fields from both the e-mail node and views mail log. This view could be filtered simply using the "sent" (yes/no) filter.