CiviCRM Community Forums (archive)

I've got a profile setup that is tied to a group.
Within the profile, I've also enabled searching on groups. Basically the big group tied to the profile contains all current members. Within that big group, I want the user to be able to search on subset (groups).

Problem is that when the query is built, it joins the "parent" group with an OR to all subset groups -- which basically means that the subset groups are always ignored.

So it looks like this --

Profile: Search within "Current Members" group.

Profile field - groups:
- Region 1
x Region 2
- Region 3
- Region 4

Result: 
Member of Group IN Region 2 or Current Members ...AND...
Group Status - "Added"

What I think it *should* be is:
Member of Group IN Current Members AND Region 2 ...AND...
Group Status - "Added"

The group attached to the profile is the "master" group. All other query criteria is a subset within that group, not an addition to it.

I've not been able to trace where the profile group is handled as it relates to profile searches. Core/BAO/CustomQuery.php seems to handle the construction of the query sql, but it doesn't include groups. Profile/Form.php is my next guess, but I don't see where the search functions are handled.

-Brian