How to sort findAll Doctrine s method

Question

I ve been reading Doctrine s documentation  but I haven t been able to find a way to sort findAll   Results    I m using symfony2   doctrine  this is the statement that I m using inside my Controller    this- gt getDoctrine  - gt getRepository  MyBundle MyTable  - gt findAll     but I want the results to be ordered by ascending usernames   I ve been trying to pass an array as an argument this way   findAll  array  username    gt   ASC       but it doesn t work  it doesn t complain either     Is there any way to do this without building a DQL query

User · Answer

You need to use a criteria  for example    lt  php  namespace Bundle Controller   use Symfony Bundle FrameworkBundle Controller Controller  use Symfony Component HttpFoundation Request  use Doctrine Common Collections Criteria         Thing controller    class ThingController extends Controller       public function thingsAction Request  request   id                 ids explode      id            criteria   new Criteria null   lt  lt DQL ordering expression gt  gt   null  null              rep       this- gt getDoctrine  - gt getManager  - gt getRepository  Bundle Thing             things    rep- gt matching  criteria           return  this- gt render  Bundle Thing things html twig                  entities    gt   things

User · Answer

this- gt getDoctrine  - gt getRepository  MyBundle MyTable  - gt findBy       username    gt   ASC

User · Answer

As  Lighthart as shown  yes it s possible  although it adds significant fat to the controller and isn t DRY   You should really define your own query in the entity repository  it s simple and best practice   use Doctrine ORM EntityRepository   class UserRepository extends EntityRepository       public function findAll                 return  this- gt findBy array    array  username    gt   ASC               Then you must tell your entity to look for queries in the repository           ORM Table name  User       ORM Entity repositoryClass  Acme UserBundle Entity Repository UserRepository       class User               Finally  in your controller    this- gt getDoctrine  - gt getRepository  AcmeBundle User  - gt findAll

User · Answer

findBy method in Symfony excepts two parameters  First is array of fields you want to search on and second array is the the sort field and its order  public function findSorted                 return  this- gt findBy   name   gt  Jhon      date   gt  DESC

User · Answer

Simple    this- gt getDoctrine  - gt getRepository  AcmeBundle User  - gt findBy      array        array  username    gt   ASC

User · Answer

This works for me    entities    em- gt getRepository  MyBundle MyTable  - gt findBy array   array  name    gt   ASC       Keeping the first array empty fetches back all data  it worked in my case

User · Answer

Try this    em    this- gt getDoctrine  - gt getManager      entities    em- gt getRepository  MyBundle MyTable  - gt findBy array    array  username    gt   ASC

User · Answer

I use an alternative to the solution that wrote nifr    resultRows    repository- gt fetchAll    uasort  resultRows  function  a   b       if   a- gt getProperty       b- gt getProperty              return 0            return   a- gt getProperty   lt   b- gt getProperty      -1   1        It s quicker than the ORDER BY clause  and without the overhead of the Iterator

User · Answer

You can sort an existing ArrayCollection using an array iterator    assuming  collection is your ArrayCollection returned by findAll     iterator    collection- gt getIterator     iterator- gt uasort function   a   b        return   a- gt getPropery    lt   b- gt getProperty      -1   1       collection   new ArrayCollection iterator to array  iterator      This can easily be turned into a function you can put into your repository in order to create findAllOrderBy   method

User · Answer

It s useful to look at source code sometimes   For example findAll implementation is very simple  vendor doctrine orm lib Doctrine ORM EntityRepository php    public function findAll         return  this- gt findBy array         So we look at findBy and find what we need  orderBy   public function findBy array  criteria  array  orderBy   null   limit   null   offset   null

User · Answer

Look at the Doctrine API source-code    class EntityRepository          public function findAll        return  this- gt findBy array

User · Answer

Modify the default findAll function in EntityRepository like this   public function findAll  array  orderBy   null         return  this- gt findBy      orderBy       That way you can use the   findAll   on any query for any data table with an option to sort the query

[symfony] How to sort findAll Doctrine's method?

Examples related to symfony

Examples related to doctrine-orm