Details
-
Type: Improvement
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7.9
-
Fix Version/s: 4.7.13
-
Component/s: None
-
Labels:
-
Documentation Required?:None
-
Funding Source:Core Team Funds
Description
I want to challenge the default of
Contribution OR Soft Credit? Is equal to Both
On the contribution detail report.
I think this is fine to have as an available option but the default should be Contributions only because
1) it's a more performant query
2) there is no visual way to realise that some rows are just duplicates of others with different names against them so it's highly likely to be misunderstood.
3) at least on 4.7.10 the 'Total Amount (Contributions)' at the bottom is incorrectly double counting. I'm not seeing that on 4.7.9
Note that there was a separate ticket that messed with groupBy & such like on reports to get greater mysql compliance that could have caused a regression between 4.7.9 & 4.7.10. I did have a high level of discomfort with those changes & have not seen QA notes on them yet.
Attachments
Issue Links
- supplements
-
CRM-18439 support MySQL 5.7 sql_mode=only_full_group_by
- Done/Fixed
- links to