Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-21514

Search builder Not Equal or Not In are not excluding contacts from results

    Details

    • Type: Bug
    • Status: Open
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 4.6.33
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Needs Funding
    • Verified?:
      No
    • Overview:
      Hide
      When you search for contacts that are in a specific group but not in another specific group, you can see that the result will be to display all contacts in the first group but not excluding those that are in the other one. This is happening on 4.6 installations.
      Show
      When you search for contacts that are in a specific group but not in another specific group, you can see that the result will be to display all contacts in the first group but not excluding those that are in the other one. This is happening on 4.6 installations.
    • How it works currently:
      Hide
      1. Create a group called "Include"
      2. Search without filters applied and select the first 5 contacts and add them to the group
      3. Create a group called "Exclude"
      4. Search without filters applied and select the first 2 contacts and add them to the group
      5. Go to Search Builder and search for
      - Contacts - Groups - Equals - Include
      - click "Another search field" and add:
      - Contacts - Groups - Not Equals - Exclude

      6. Click Search
      --> all 5 contacts will be listed in the search results
      7. Then add 1 more contact to group Exclude, but make sure this contact is not in the group Include!
      --> the search result will not display this new contact, it only displays those that are in group Include too - this is correct
      8. Or just search simply for
      - Contacts - Groups - Not Equals - Exclude
      --> will display all contacts, even those that are in group Exclude
      Show
      1. Create a group called "Include" 2. Search without filters applied and select the first 5 contacts and add them to the group 3. Create a group called "Exclude" 4. Search without filters applied and select the first 2 contacts and add them to the group 5. Go to Search Builder and search for - Contacts - Groups - Equals - Include - click "Another search field" and add: - Contacts - Groups - Not Equals - Exclude 6. Click Search --> all 5 contacts will be listed in the search results 7. Then add 1 more contact to group Exclude, but make sure this contact is not in the group Include! --> the search result will not display this new contact, it only displays those that are in group Include too - this is correct 8. Or just search simply for - Contacts - Groups - Not Equals - Exclude --> will display all contacts, even those that are in group Exclude
    • How it should work:
      Hide
      1. Create a group called "Include"
      2. Search without filters applied and select the first 5 contacts and add them to the group
      3. Create a group called "Exclude"
      4. Search without filters applied and select the first 2 contacts and add them to the group
      5. Go to Search Builder and search for
      - Contacts - Groups - Equals - Include
      - click "Another search field" and add:
      - Contacts - Groups - Not Equals - Exclude

      6. Click Search
      --> 3 contacts should be displayed
      7. Then add 1 more contact to group Exclude, but make sure this contact is not in the group Include!
      --> the search result will not display this new contact, it only displays those that are in group Include too - this is correct
      8. Or just search simply for
      - Contacts - Groups - Not Equals - Exclude
      --> should display only those contacts who are not in group Exclude
      Show
      1. Create a group called "Include" 2. Search without filters applied and select the first 5 contacts and add them to the group 3. Create a group called "Exclude" 4. Search without filters applied and select the first 2 contacts and add them to the group 5. Go to Search Builder and search for - Contacts - Groups - Equals - Include - click "Another search field" and add: - Contacts - Groups - Not Equals - Exclude 6. Click Search --> 3 contacts should be displayed 7. Then add 1 more contact to group Exclude, but make sure this contact is not in the group Include! --> the search result will not display this new contact, it only displays those that are in group Include too - this is correct 8. Or just search simply for - Contacts - Groups - Not Equals - Exclude --> should display only those contacts who are not in group Exclude
    • Acceptance Criteria:
      Hide
      - should exclude contacts who are in group specified as Not Equals or Not In
      - same happens when you do the same with tags
      Show
      - should exclude contacts who are in group specified as Not Equals or Not In - same happens when you do the same with tags

      Attachments

        Activity

          People

          • Assignee:
            Unassigned
            Reporter:
            ritatorok Rita Torok
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated: