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

Activity based Views that use Groups as Filters results in double joins

    Details

    • Type: Bug
    • Status: Open
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 4.7.16
    • Fix Version/s: None
    • Labels:
      None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code
    • Verified?:
      No

      Description

      I set up an Activity based View to be filtered on a Group that the Target was in.

      Outcome was the rows for the Target contact went from 1 per Activity to multiple rows (I thought it was showing as many rows as there were Groups that the contact was in).

      Torrance says he confirmed that the _civicrm_group_contact_union table is being joined twice but that this issue exists without this module too: ie in a standard civi install, the civicrm_group_contact table is also being joined twice. These leads to a doubling of rows.

        Attachments

        1. fz_test_for_crm_20223.txt
          4 kB
          Peter Davis
        2. screenshot-1.png
          39 kB
          Jitendra Purohit

          Activity

            People

            • Assignee:
              peted Peter Davis
              Reporter:
              petednz Peter Davis
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: