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) »
  • Searching for members who have not attended an event
Pages: [1]

Author Topic: Searching for members who have not attended an event  (Read 556 times)

rfenwick

  • I’m new here
  • *
  • Posts: 20
  • Karma: 1
Searching for members who have not attended an event
March 17, 2011, 03:27:14 pm
Hi,

I'm trying to run a search to return only those members who have not attended an event ever - ie no participant status has ever been logged for them. Is that possible? I've tried for an hour or so without success.

Many thanks!

Robin

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: Searching for members who have not attended an event
March 17, 2011, 03:29:52 pm
Robin,

try creating a Group containing all the members. Then find all attendees of the Event and use the Action 'remove from Group'. The Group is then all the members who didn't attend the Event.

Ken

rfenwick

  • I’m new here
  • *
  • Posts: 20
  • Karma: 1
Re: Searching for members who have not attended an event
March 17, 2011, 03:37:26 pm
Ken, thank you very much for that - that lead me to what I think is a solution which will work as a smart group (given that we hold events regularly - objective is to reach out more to those who have never attended an event)

I used the search builder:

Membership / Membership Type / IS NOT NULL
Participant / Participant status / IS NULL

Just looking at the results, they're what I'd expect to see. Thank you!

rfenwick

  • I’m new here
  • *
  • Posts: 20
  • Karma: 1
Re: Searching for members who have not attended an event
March 17, 2011, 03:48:16 pm
No, I was completely wrong and you are completely right - will do it your way! :)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Searching for members who have not attended an event

This forum was archived on 2017-11-26.