4940: XML DB aggregate expression support - Composr CMS feature tracker

ID	Project	Category	View Status	Date Submitted	Last Update

4940	Composr	core_database_drivers	public	2022-09-17 00:02	2022-09-17 00:02

Reporter	Chris Graham	Assigned To	Guest
Priority	normal	Severity	feature
Status	new	Resolution	open

Summary	4940: 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.
Attach Tags	(Separate by ",")

Time estimation (hours)	3
Sponsorship open

Date Added	Member	Amount Sponsored

View Status	Private (for security issues or disclosing of private information; if you submit as a guest, you will not be able to see your submission)
Note
Upload Files Maximum size: 32,768 KiB	Attach files by dragging & dropping, selecting or pasting them.
You are not logged in	You are not logged in. This means you will not get any e-mail notifications. And if you reply, we will not know for sure you are the original poster of the issue.

Date Modified	Username	Field	Change
2022-09-17 00:02	Chris Graham	New Issue