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

mailing report: unique opens detail view inaccurate

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.7.18
    • Fix Version/s: 4.7.23
    • Component/s: CiviMail, NYSS
    • Labels:
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Core Team Contract
    • Verified?:
      No

      Description

      when viewing a mailing report, there is a stat for unique opens and total opens. the stats on that overview page are accurate, but if you click to view the detailed report, the unique opens listing does not actually show you unique values.

      this is due to a flaw in the query (CRM_Mailing_Event_BAO_Opened::getRows()) – if the distinct flag is passed, it groups by the event queue id AND the timestamp, where it should only group by the event queue id.

        Attachments

          Activity

            People

            • Assignee:
              lcdweb Brian Shaughnessy
              Reporter:
              lcdweb Brian Shaughnessy
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: