Author Topic: Find members with no contributions? (Read 3095 times)

matiasp · August 05, 2013, 06:00:03 pm

Hi there,
Is there a way to use "Find Contacts - Advanced Search" to find contacts with active memberships but no contributions?
It doesn't seem like it from the form: I can specify a contribution amount, but no "no contributions."
I imagine I can do this using an OUTER JOIN in mysql, but I'd love to have a Smart Group for this in Civi instead.

Thanks!
matias

galgeek · August 06, 2013, 11:50:21 am

Perhaps someone more experienced than I can offer a better way, but the way I've done this, via the web interface, is to create a group including all contacts, then use Advanced Search to find all contacts with contributions, and remove them from the group of all contacts just created.

If you don't want that group then to show up as a past group for all your donating contacts, find all its current members and add them to a new group, e.g. "no donation record 13-08-06" and delete the old.

CiviCRM Community Forums (archive)

News:

Author Topic: Find members with no contributions? (Read 3095 times)

matiasp

Find members with no contributions?

galgeek

Re: Find members with no contributions?