Why Are Some Emails Missing From the
Updated 8 days ago
Why are some emails missing from the
EMAIL_TAG table? Shouldn't the table include all email with tags?
When you send a list email, only one record has a tag and appears in the
EMAIL_TAG table. Records for individual emails sent to recipients included in the list don't have tags.
You can use the following SQL query to see a list of all emails with a tag:
select t.id as tag_id, t.name as tag_name, et.*, e.* from email e left join email_tag et on e.id = et.email_id left join "tag" t on et.tag_id = t.id where e.list_email_id is not null;content_copy