How to order results with findBy() in Doctrine
I am using the findBy()
method on a Doctrine repository:
$entities = $repository->findBy(array('type'=> 'C12'));
How can I order the results?
Solution 1:
The second parameter of findBy
is for ORDER.
$ens = $em->getRepository('AcmeBinBundle:Marks')
->findBy(
array('type'=> 'C12'),
array('id' => 'ASC')
);
Solution 2:
$ens = $em->getRepository('AcmeBinBundle:Marks')
->findBy(
array(),
array('id' => 'ASC')
);
Solution 3:
$cRepo = $em->getRepository('KaleLocationBundle:Country');
// Leave the first array blank
$countries = $cRepo->findBy(array(), array('name'=>'asc'));