Unexpected search results with Search Builder - NOT IN operator?

[welly]

Hello all,

The civicrm data set I'm working with has many thousands of spam contacts that I'm trying to delete. I'm trying to return users that don't belong to a particular group.

I've set up my search criteria as follows:

Include contacts where:
Contacts | Contact Type | = | Individual
Contacts | Group(s) | != | AGM Group

CivCRM shows the query as:

Code: [Select]

Contact Type - 'Individual' ...AND...
Contacts != AGM Group AND Group Status - "Added"

Yet this returns users in the AGM Group.

Changing the search to:

Include contacts where:
Contacts | Contact Type | = | Individual
Contacts | Group(s) | IN | AGM Group

CiviCRM returns the search results and shows the query as:

Code: [Select]

Contact Type - 'Individual' ...AND...
Contacts IN AGM Group AND Group Status - "Added"

The results are correct for this. There does not appear to be a NOT IN operator which I believe should in theory return the desired results. Does anyone have any suggestions?

I want to return users NOT in a group or a number of groups, who I can then delete.

Thanks!

welly

[JonGold]

Hi Welly,

Easiest way to do this is probably to skip Search Builder.  Create a group of all your contacts ("All Contacts") then use the custom search "Include/Exclude by Group/Tag" to include "All Contacts" and exclude the group in question.

[welly]

Thanks kindly, Jon! I'll try that out.