Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7.18
-
Fix Version/s: 4.7.23
-
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.