CiviReport: Contribution Detail Report Joining Incorrectly on civicrm_note
Overview
When 'Contribution Note' is selected as a column in a Contribution Detail report, the join is treated as required and all contributions in the results without notes are filtered out.
This issue occurs when using the 'Contribution Detail' report, 'Extended Report - Contributions' report, and 'Extended Report - Bookkeeping with extra fields' report.
Thankfully, reports created in SearchKit function properly (all contributions are returned in the results) and contribution search exports are also functioning properly (including 'Contribution Note' in the exported fields does not affect the records exported).
Reproduction steps
- example.com/civicrm/report/contribute/detail?reset=1
- View results with Columns > Contribution Note toggled off
- Toggle Contribution Note on, run report again, note that fewer records are returned
Environment information
- CiviCRM: 5.69.2
- PHP:8.1.27
- Drupal: 7.99
- MySQL: 8.0.33
Comments
This only recently became an issue after making a minor upgrade to 5.69.2