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
Post a Comment