View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004940 | Composr | core_database_drivers | public | 2022-09-17 00:02 | 2022-09-17 00:02 |
| Reporter | Chris Graham | Assigned To | |||
| Severity | Feature-request | ||||
| Status | non-assigned | Resolution | open | ||
| Product Version | |||||
| Fixed in Version | |||||
| Summary | 0004940: XML DB aggregate expression support | ||||
| Description | Currently the XML database driver does not support expressions involving aggregate functions. Consider this query we were considering doing... SELECT recipient_id,SUM(amount_points)+SUM(gift_points)-(SELECT SUM(amount_points)+SUM(gift_points) FROM cms11_points_ledger refund WHERE refund.status='refund' AND refund.date_and_time>=START AND refund.date_and_time<END AND refund.recipient_id=normal.recipient_id) AS points FROM cms11_points_ledger normal WHERE normal.status='normal' AND normal.date_and_time>=START AND normal.date_and_time<END GROUP BY recipient_id ORDER BY points DESC; We cannot do that because of the limitation in the XML database driver. | ||||
| Tags | No tags attached. | ||||
| Time estimation (hours) | 3 | ||||
| Sponsorship open | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-09-17 00:02 | Chris Graham | New Issue |
