php - Zendframework2 using Doctrine orderBy is not "ordering" at all -

i @ point out of ideas. want order categories doctrine. after litle doctrine documentation reading uses following in controller:

$categories = $em->getrepository('\cbox\entity\category')->findby(array('title' =>'news'), array('createdtime' => 'desc')); 

both column's exist nor php/doctrine/mysql error. right aproach? tried using orderby annotations in entity no success either:

/** * @orm\onetomany(targetentity="cbox\entity\category", mappedby="box") * @orm\orderby({"createdtime" = "desc"}) */ protected $category; 

i did read querybuilder , dql seems litle bit of overkill orderby set.

any appreciated. hope thats enough code guys picture. rather have "problematic" parts shown here tons of code.

try

 $qb = $em->createquerybuilder();  $qb->select('u')  ->from('cbox\entity\category u')  ->where('u.title = :title')  ->orderby('u.createdtime', 'desc')  ->setparameter('title', news); 

now if cbox\entity\category or \cbox\entity\category correct entity must work. here approach can same thing without setparameter() not recommend it.

  $qb->select('u')  ->from('cbox\entity\category u')  ->where('u.title = news')  ->orderby('u.createdtime', 'desc'); 

further more if want see how fetch result out of $qb suggest follow link http://docs.doctrine-project.org/en/latest/reference/query-builder.html