Details
-
Type: Bug
-
Status: Reopened
-
Priority: Important
-
Resolution: Unresolved
-
Affects Version/s: 4.7.15
-
Fix Version/s: 4.7.17
-
Component/s: Core CiviCRM, Drupal Integration Modules
-
Labels:
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Core Team Funds
-
Verified?:No
Description
In Drupal view when we using filter for contact sub type,
query is being built as "WHERE (( (civicrm_contact.contact_sub_type IN ('Student')) ))"
but in database contact sub type is stored with CiviCRM separator.
so when contact having more than one role this query is not working as expected.