ZuckerReports - Need Help!

[rschultz]

Am using SugarTags to tag Contacts. This done would like to create a ZuckerReport to list ALL Contacts (last_name, first_name & email1) who have been tagged with a specific tag. I've been able to successfully create a Report Query to find all Contact id's who match a specific tag; for example...

select contacts_id from tags_contacts where tags_id = (select id from tags where name = "VxPC Internet Filter")

The problem is that when I apply this as a filter to the All Contacts listing report it doesn't list ALL matching Contacts but rather lists ALL matching Contact id's in the Parameter drop-down which in turn only displays one Contact at a time. In the end, my goal is to generate a tagged contact list I can use to feed into an email marketing system like Constant Contact.

Any help would be greatly appreciated!

[rschultz]

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"...

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