[TYPO3-dev] Extbase + group by + having

[Bernhard Kraft]

Hi,

I know it has been asked quite some times. But is there a reason extbase 
does not support the "group by" SQL statement including "having"?

There are different proposed solutions but most suggest to use a custom 
query using $query->statement(). This is fine as long as one does not 
use the paginate widget. The paginate widget does not work with custom 
queries.

I know sometimes it is possible to adapt the data model and or queries. 
For example to resolve a GROUP BY problem one could look at the 
relations from "the other side" but this does not work in every case. 
Especially if the sorting criteria defined for the relation is different 
from what it should be within the query.



greetings,
Bernhard