[TYPO3-mvc] Extbase query sorting according MM table

[Adrien Crivelli]

Hi,

Maybe you could use statement() and a custom query in your Repository.
Something similar to:


$query = $this->createQuery();
> $query->statement("SELECT tx_tagpack_tags.*
> FROM  tx_tagpack_tags
> INNER JOIN  tx_tagpack_tags_relations_mm
> ON (uid_foreign = uid)
>                         ORDER BY stuff
>                  ");
>
> return $query->execute();


Did't test it out though... good luck !




On 21 June 2012 02:55, ktt <kestutis98 at yahoo.com> wrote:

> Hello,
>
> I would like to select objects and sort them in DESC order according
> 'sorting' field in
> MM table.
>
> Is there any method in Extbase to select objects according to 'sorting'
> field and specifing DESC or ASC?
>
> Thank you in advance,
> Kast
> _______________________________________________
> TYPO3-project-typo3v4mvc mailing list
> TYPO3-project-typo3v4mvc at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc
>