symfony - Doctrine2 Join count on same table returning empty array -


$messagequery             ->select('m, count(pm) newresponses')             //->addselect($messagequery->expr()->countdistinct('pm.id'))             ->from('entities:privatemessage', 'm')             ->where('m.employeeid = :employeeid , m.responseto = 0')             ->innerjoin('entity:privatemessage', 'pm', 'with', 'pm.responseto = m.id , pm.employeeread = 0')             ->setparameter('employeeid', $employeeid)             ->setfirstresult($offset)             ->setmaxresults($max)             ->addgroupby('m.id')             ->orderby('m.id', 'desc'); 

let's assume there 2 messages employeeid = 1 , responseto = 0. 1 of messages has 2 responses (therefore 2 other records responseto = messageid). other has none. result expect query 2 arrays entity object index 0, , count index numresponses (value of 2 first row, 0 second). i'm getting empty array on $messagequery->getquery()->getresult();

does have ideas why may happening? there obvious i'm missing here?

actually, seem have fixed switching leftjoin.


Comments

Popular posts from this blog

blackberry 10 - how to add multiple markers on the google map just by url? -

php - guestbook returning database data to flash -

delphi - Dynamic file type icon -