Error DB: No such field - Contribution Summary Report
Overview
Hello, When try to use report contribution summary with col "Soft Credit Amount Stats" and add any filter of contribution stats ex: Cotribution Count "total_count_value" the report show error: "DB Error: no such field". Maybe we dont use this filters when use this col, but I think is a error.
Reproduction steps
- Create a report "Contribution Summary Report "
- Select col: "Soft Credit Amount Stats"
- Add filter: "Contribution Count" > 1 for example
Comments
Tested on dmaster: https://dmaster.demo.civicrm.org/
- Report breaks in this point of code: https://github.com/civicrm/civicrm-core/blob/master/CRM/Report/Form/Contribute/Summary.php#L664
- I think because the query only have a cols for stats of soft credits: https://github.com/civicrm/civicrm-core/blob/master/CRM/Report/Form/Contribute/Summary.php#L635