Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Doctrine 2.1: How to orderBy aggregate field in a collection?

I have an entity with a ArrayCollection field. In the annotations I can write

@ORM\OrderBy({"somefield" = "DESC"})

and the collection I get from that entity will be automatically ordered.

My question is if it is possible to order by aggregate fields?

My current issue: I have 2 fields in the collection entity: visited and shown, I would like to sort the collection by a rating index, which is: visited / shown. I tried writting it in the annotations, but it says it should be a valid field. I know how to do this with DQL, but I don't know how to recreate it in the Entity's declaration with annotations.

Thanks in advance!

like image 979
Tony Bogdanov Avatar asked Mar 06 '12 22:03

Tony Bogdanov


2 Answers

Not quite sure I do understand your problem. But what does

@ORM/OrderBy({"visited" = "DESC", "shown" = "DESC"})

give as result?

From http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/annotations-reference.html#annref-orderby :

The DQL Snippet in OrderBy is only allowed to consist of unqualified, unquoted field names and of an optional ASC/DESC positional statement. Multiple Fields are separated by a comma (,). The referenced field names have to exist on the targetEntity class of the @ManyToMany or @OneToMany annotation.

like image 180
Rene Terstegen Avatar answered Oct 06 '22 01:10

Rene Terstegen


You need math operation in ORDER BY statement - in SQL it would be ORDER BY visited/shown DESC. I think it's not possible to do within annotations.

like image 37
Maciej Pyszyński Avatar answered Oct 06 '22 00:10

Maciej Pyszyński