Author Topic: "Advanced Search returns results that match ALL items you enter/check" ? (Read 1049 times)

brunodbo · July 10, 2009, 07:16:53 am

The CiviCRM documentation states the following:

"Unless otherwise noted, filling out more than one field in the Advanced Search window will return results that match ALL items you enter or check. For example, searching on the name "Jones" and Zip Code "02134" will show only those contacts that match BOTH items."
(http://wiki.civicrm.org/confluence/display/CRMDOC/Advanced+Search)

Is it possible to do a search where results are returned that match one of the selected/entered items (instead of results having to match ALL results), or would this require a hack? I'm on CiviCRM 2.0.5.

ctarascio · July 10, 2009, 07:38:41 am

Hi,
If I understand you correctly, you want to be able to search for "this" OR "that" and not just "this" AND "that". If this is what you want I believe it is possible to do this using search builder. Note though, that I tested this on 2.2.5, so I don't know if there is something different with search builder in 2.0.5.

--Enter your first search criteria in the "Include contacts where" section.
--Then, enter the second set of criteria in the "also include contacts where" section.
--The results returned should include contacts that meet either criteria.
--Whereas if you enter both sets of criteria in the "include contacts where" section the results will only include contacts that meet
both sets of criteria

Does this help?

Cynthia

brunodbo · July 10, 2009, 08:23:24 am

Thanks for the quick reply.

I had found the search builder, but I was wondering if there was a solution where I could offer this functionality (the 'OR' search) to non-tech-savvy users, who don't necessarily understand how to build a search query themselves.

Donald Lobo · July 10, 2009, 08:28:17 am

if you only want to search on a limited number of fields, consider building a custom search. You can then expose the AND/OR functionality to the user. alternatively you can also try the views2 integration depending on your needs

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: "Advanced Search returns results that match ALL items you enter/check" ? (Read 1049 times)

brunodbo

"Advanced Search returns results that match ALL items you enter/check" ?

ctarascio

Re: "Advanced Search returns results that match ALL items you enter/check" ?

brunodbo

Re: "Advanced Search returns results that match ALL items you enter/check" ?

Donald Lobo

Re: "Advanced Search returns results that match ALL items you enter/check" ?