[TYPO3-mvc] setOrderings by count

Franz Koch typo3.RemoveForMessage at elements-net.de
Mon Oct 25 18:04:13 CEST 2010


Hey,

> at the moment we can use setOrderings() just with properties, aight?
>
> seems like I can't build the following with the query-object:
>
> select plz, count(uid) as counter group by plz order by counter limit 5
>
> would it make sense to kind of implement this count() for usage in the
> statement (not the count()-method itself, as it is allready there ;) )
> somehow?

aye captain, that's not possible atm - so you have to use a custom 
statement for that. If you're a lazy guy like me you could also have 
extbase do most of the work and let it crate raw query parts that you 
manipulate afterwards. I wrote somewhere in this list how I did this.

-- 
kind regards,
Franz Koch


More information about the TYPO3-project-typo3v4mvc mailing list