We're updating the issue view to help you get more done. 

Add 'autoGroup' argument to selectData()

Description

The idea here would be that for selectData() statements with a dynamic set of fields to select, the core system would be able to detect agreggate fields and group by all the other fields in the query.

This will remedy DB problems where group by needs to be a full list of fields, rather than just "id" for example (that MySQL/MariaDB allow you to do). It also allows us to automagically do group by for formula fields

Status

Assignee

Unassigned

Reporter

Dominic Watson

Accepted

Yes

Fix versions

Priority

Medium