Annotation @OrderBy

symfony doctrine-orm doctrine symfony-2.3
Lughino picture Lughino · Aug 12, 2013 · Viewed 13.8k times · Source

I'm trying to automatically order the results of a report by the ManyToMany annotation @OrderBy:

/**
 * @ORM\ManyToMany(targetEntity="Artist", inversedBy="soundtrack", cascade={"persist", "remove"})
 * @ORM\JoinTable(name="soundtrack_artist")
 * @OrderBy({"name" = "ASC", "surname" = "ASC"})
 **/
private $artists;

but it gives me this error:

[Semantical Error] The annotation "@OrderBy" in property
Acme\UserBundle\Entity\Soundtrack::$artists was never imported.
Did you maybe forget to add a "use" statement for this annotation?

I tried to add also:

use Doctrine\ORM\Mapping\OrderBy;

But the error remains! I'm doing something wrong?

Answer

Prasad picture Prasad · Aug 2, 2014

Not sure if you found the answer, but this worked for me:

@ORM\OrderBy

Related questions

Symfony - How to access entity's repository

There are several ways that we can access the entity's repository in Symfony2 controllers or services which each has its advantage and disadvantage. First I list them here and then asking if there is any better solution or these are …

Read More
How to encode Doctrine entities to JSON in Symfony 2.0 AJAX application?

I'm developing game app and using Symfony 2.0. I have many AJAX requests to the backend. And more responses is converting entity to JSON. For example: class DefaultController extends Controller { public function launchAction() { $user = $this->getDoctrine() ->getRepository('UserBundle:…

Read More
Doctrine 2 can't use nullable=false in manyToOne relation?

An User has one Package associated with it. Many users can refer to the same package. User cannot exists without a Package defined. User should own the relation. Relation is bidirectional, so a Package has zero or more users in …

Read More