Answers.Body: <p>CiviCRM is good at doing searches for a "negative" when it's, "find an empty field"; you can use <strong>Search menu » Search Builder</strong> for that.  However, for finding whether someone is missing an Activity, Relationship, etc. you need a custom search.  By default, CiviCRM has such a custom search for groups and tags, but not relationships.</p>
  
  <p>Until someone writes that search, here's the workaround:</p>
  
  <ul>
  <li>Do a search with no criteria, which will return all your contacts.  Create a smart group from this search called "All Contacts".</li>
  <li>Do an Advanced Search for folks that DO have the supervisor relationship.  Create a second smart group called "Volunteers with Supervisors".</li>
  <li><em>Note:</em> If not ALL of your contacts are volunteers, then modify both of the searches above to only search the "Volunteers" group.</li>
  <li>Go to <strong>Search menu » Custom Searches</strong>.</li>
  <li>Click <strong>Include / Exclude Search</strong>.  On older versions of CiviCRM, this is called, <strong>Include/Exclude by Group/Tag</strong>.</li>
  <li>For "Include Groups", select "All Contacts".  For "Exclude  Groups", select "Volunteers with Supervisors".</li>
  </ul>
  
  <p>The search result you get back is the list of "All Contacts" minus "Volunteers with Supervisors" - which should be volunteers without supervisors.  You can create a smart group out of it so that less data-savvy users can just use the new smart group to generate the list.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-17T15:19:30.170Z
Answers.LastActivityDate: 2017-08-17T15:19:30.170Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>One way of approaching this is to split it into two searches:</p>
  
  <p><strong>A</strong> volunteers</p>
  
  <p><strong>B</strong> volunteers with a supervisor</p>
  
  <p>Then subtracting B from A to give you volunteers without a supervisor.</p>
  
  <p><strong>One off</strong></p>
  
  <p>If you are doing this on a one off basis, you should:</p>
  
  <ol>
  <li>create a group for A</li>
  <li>do a search for B and select remove from group from the actions menu </li>
  <li>remove the contacts in B from group A</li>
  </ol>
  
  <p><strong>Ongoing / Smart group</strong></p>
  
  <p>If you are doing this search on a ongoing basis, it makes sense to create a smart group.</p>
  
  <ol>
  <li>create smart groups for A and B</li>
  <li>create another smart group using the '<em>Include / Exclude Search</em>' that can be found in <em>Custom Searches</em>.</li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-17T15:22:23.950Z
Answers.LastActivityDate: 2017-08-17T15:22:23.950Z
Answers.UserDisplayName: michaelmcandrew
Body: <p>I need to get a list of Volunteers (contacts) who DON'T have a supervisor (relationship) ...I've tried Advanced Search and looking for relationships, and I've just tried Search Builder. I can put the ones who DO in a smart group, but can't find a way of putting the ones who don't...Help!</p>
  
Tags: <custom-search>
Title: Negative searches: volunteers WITHOUT relationship to supervisor
ThreadText: # Negative searches: volunteers WITHOUT relationship to supervisor
  
  (Asked by: username_0 on 2017-08-17)
  
  I need to get a list of Volunteers (contacts) who DON'T have a supervisor (relationship) ...I've tried Advanced Search and looking for relationships, and I've just tried Search Builder. I can put the ones who DO in a smart group, but can't find a way of putting the ones who don't...Help!
  
  **Tags:** custom-search
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2017-08-17. Score: 1
  
  CiviCRM is good at doing searches for a "negative" when it's, "find an empty field"; you can use **Search menu » Search Builder** for that. However, for finding whether someone is missing an Activity, Relationship, etc. you need a custom search. By default, CiviCRM has such a custom search for groups and tags, but not relationships.
  
  Until someone writes that search, here's the workaround:
  
  * Do a search with no criteria, which will return all your contacts. Create a smart group from this search called "All Contacts".
  * Do an Advanced Search for folks that DO have the supervisor relationship. Create a second smart group called "Volunteers with Supervisors".
  * *Note:* If not ALL of your contacts are volunteers, then modify both of the searches above to only search the "Volunteers" group.
  * Go to **Search menu » Custom Searches**.
  * Click **Include / Exclude Search**. On older versions of CiviCRM, this is called, **Include/Exclude by Group/Tag**.
  * For "Include Groups", select "All Contacts". For "Exclude Groups", select "Volunteers with Supervisors".
  
  The search result you get back is the list of "All Contacts" minus "Volunteers with Supervisors" - which should be volunteers without supervisors. You can create a smart group out of it so that less data-savvy users can just use the new smart group to generate the list.
  
  
  ---
  
  ### Answer by username_2 on 2017-08-17. Score: 0
  
  One way of approaching this is to split it into two searches:
  
  **A** volunteers
  
  **B** volunteers with a supervisor
  
  Then subtracting B from A to give you volunteers without a supervisor.
  
  **One off**
  
  If you are doing this on a one off basis, you should:
  
  1. create a group for A
  2. do a search for B and select remove from group from the actions menu
  3. remove the contacts in B from group A
  
  **Ongoing / Smart group**
  
  If you are doing this search on a ongoing basis, it makes sense to create a smart group.
  
  1. create smart groups for A and B
  2. create another smart group using the '*Include / Exclude Search*' that can be found in *Custom Searches*.
  
  
  ---
  
  