CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Search for members NOT in a group
Pages: [1]

Author Topic: Search for members NOT in a group  (Read 5870 times)

sstern

  • I’m new here
  • *
  • Posts: 20
  • Karma: 0
  • CiviCRM version: 4.3.4
  • CMS version: Drupal
  • MySQL version: 5.5.29
  • PHP version: 5.3.3
Search for members NOT in a group
June 16, 2013, 03:57:34 pm
We send a newsletter to our membership via email or postal mail.  I have a mailing list on mailchimp that syncs to the group "newslettter_email".  So, those who should receive the postal mail version are "all current members who are not in the group newsletter_email".  Is there a way to set up a smart group to manage this?

sstern

  • I’m new here
  • *
  • Posts: 20
  • Karma: 0
  • CiviCRM version: 4.3.4
  • CMS version: Drupal
  • MySQL version: 5.5.29
  • PHP version: 5.3.3
Re: Search for members NOT in a group
June 16, 2013, 04:49:45 pm
Here's my solution:

1) create a smart group for all_members, includes everyone who is a member.
2) used the custom "include/exclude" search to include all_members and exclude newsletter_mail and include tags "newsletter_postal_always" and "advertiser"
3) save the result as a new smart group "postal_newsletters".

A long, strange trip.

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Search for members NOT in a group
June 17, 2013, 02:19:47 pm
Search builder lets you combine AND, OR and NOT operators, and might could give you the desired result.
Try asking your question on the new CiviCRM help site.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Search for members NOT in a group

This forum was archived on 2017-11-26.