[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