Author Topic: advanced search yields same result set regardless of operator (and/or) (Read 738 times)

ctarascio · September 28, 2011, 06:57:49 am

hi,
using advanced search, i did the following on both our 3.4.5 version and on the demo site and received the same results:

--advanced search with "and" operator for group=newsletter subscribers yielded 60 records
--edit the search criteria and add the summer program volunteers as second group yields 75 records
--but if you view the record for e.g. mrs fraddie j adams sr, she only has one group=newsletter subscribers
--changing the operator from and to or yields 75 records

so it seems like the "and" operator is being treated as "or". is this the expected behavior or is something wrong with the code? if the latter may i post a bug report in the issue tracker?

thanks,
cynthia

Donald Lobo · September 28, 2011, 07:21:08 am

The AND/OR operator is across the various form elements. Within each form element the current code was used (based on the MIH spec and what was feasible for the number of hours)

So for groups, its always an OR. An AND is significantly more complex and will require a lot more code (maybe even a different query construction). There is an Include / Exclude groups / tags custom search that folks should use if u want to find contacts that belong to all groups (yes its more limited than advanced search)

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: advanced search yields same result set regardless of operator (and/or) (Read 738 times)

ctarascio

advanced search yields same result set regardless of operator (and/or)

Donald Lobo

Re: advanced search yields same result set regardless of operator (and/or)