Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.2.8
-
Fix Version/s: 4.3.0
-
Component/s: Drupal Integration Modules
Description
This issue popped up for us when trying to filter by tag. The SQL query views is generating attempts to filter on civicrm_tag.name using the tag id.
The attached patch fixes this BUT it subsequently breaks sorting based on tag name/group name, as behind the scenes views will be sorting based on id. I'm not sure how to fix this — but I note sorting is broken in the exact same way for, eg. activity_type, website_type, phone_type.
The issue all view data that uses the civicrm_handler_filter_pseudo_constant handler for filters, but does not modify the 'real field' to the constant id. I've only spotted it being broken for these two types.