CiviCRM Community Forums (archive)

Advanced search (and every other search and report I can find) uses "OR" when selecting multiple groups and searching.  I'd like to search for contacts who are in ALL of the following groups: A, B and C.   Contacts in only group A and C will not be returned.

Can this be done in the GUI?

UPDATE: I've been informed this is not currently possible.  I'm looking for advice, estimates or best practices to implement this search capability within advanced search or a custom search.

I ran into this problem recently when trying to do an AND search on two smart groups.  The solution above seems to work if you are looking at two static groups or one static group and one smart group, but not two smart groups.

My recollection is that this has worked in the past when looking at smart groups only...but they say memory is the second thing to go.

Any one else having this problem or having success looking at smart groups only?

Morgan

lobo-

Just confirmed in sandbox (d6).  three static groups exited (ID # 2 3 & 4) and I created two smart groups (ID # 7 criteria is membership in either 2 or 4; ID #8 criteria is membership in either 3 or 4). Groups 2 and 4 have overlapping members.

Search builder acted as expected when looking at either two static groups (2 and 4) or one static group and one smart group (2 and 7) or two static groups and one smart group (2 and 4 and 7).

It returned no results (erroneously) when searching the two smart groups (7 and 8 ), or on the two smart groups and one static group (4 and 7 and 8 ).

Morgan