Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-12009

Views: Filter by tag, group title (possibly others) broken

    Details

      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.

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              torrance123 Torrance
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: