After a significant time investment, I believe (?) I confirmed ZuckerReports basic query could not support the complexity of what I was trying to do. I ended up being able to achieve my goal externally using Microsoft's SQL Express Management Studio. In the hopes it might help others, here's the SQL Query I created to create a list (firstname, email) for those contacts tagged (using SugarTags) as "VxPC Internet Filter"...
Code:
SELECT c.first_name, ea.email_address
FROM contacts c
INNER JOIN email_addr_bean_rel eabr
ON c.id = eabr.bean_id JOIN email_addresses ea
ON eabr.email_address_id = ea.id
INNER JOIN tags_contacts tc
ON c.id = tc.contacts_id JOIN tags t
ON tc.tags_id = t.id
WHERE t.name = 'VxPC Internet Filter'
ORDER BY c.first_name ASC
Bookmarks