Author Topic: Unexpected search results with Search Builder - NOT IN operator? (Read 305 times)

welly · March 26, 2015, 12:19:13 am

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:

Quote

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:

Quote

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 · March 26, 2015, 07:09:44 am

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 · March 26, 2015, 10:53:58 pm

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

CiviCRM Community Forums (archive)

News:

Author Topic: Unexpected search results with Search Builder - NOT IN operator? (Read 305 times)

welly

Unexpected search results with Search Builder - NOT IN operator?

JonGold

Re: Unexpected search results with Search Builder - NOT IN operator?

welly

Re: Unexpected search results with Search Builder - NOT IN operator?