CiviCRM Community Forums (archive)

Hey all,
It looks like Advanced Search is incorrectly filtering with inputs of contact types if a user selects a parent Type with a Sub-Type of a different parent.
Here is our scenario - we have two parent types ("Individual" plus "Organization", as usual).  We then also have an "Organization" sub-type of "Church".  If an admin selects "Individual" plus "Church" in Advanced Search, we expect it to output both individuals and church-only organizations.  What we see instead is this (on the results screen):
Contact Type - 'Organization' or 'Individual' ...AND...
Contact Subtype - 'Church' ...AND...

It looks like, because Civi holds the Type and Sub-Type of a contact in 2 fields in the db, it splits out the filtering in the query.  Of course, that's not at all what we want.  What we want is something like this:
(Contact Type - 'Organization' and Contact Subtype - 'Church')
OR (Contact Type - 'Individual')

We basically need Advanced Search to "group" the WHERE clauses for contact_type and contact_sub_type together so the filtering is done correctly.

Is there a simple solution to this or should I be filing a bug on it?