[Symfony][Symfony2][Doctrine2]Natywny sql problem z zapytaniem zwraca null Opcje

[silverwind]

Dlaczego mi zwraca null przy natywny sql w zapytaniu. Dump w szablonie są same null.

[PHP] pobierz, plaintext 
public function getExpensesByProperty()
  {
 
    $rsm = new ResultSetMapping;
 
    $rsm->addEntityResult('User\UserBundle\Entity\User', 'u');
 
    $rsm->addFieldResult('u', 'username', 'username');
 
    $sql = "
            SELECT username
            FROM users
 
         ";
 
 
 
 
    $query= $this->_em->createNativeQuery(
      $sql, $rsm
    );   
 
 
 
    return $query->getResult();
 
  }
}
[PHP] pobierz, plaintext 

[silverwind]

Teraz mam problem ze SUMĄ . W ogóle ją nie wyświetla

[PHP] pobierz, plaintext 
public function getExpensesByProperty()
  {
 
    $rsm = new ResultSetMapping;
 
    $rsm->addEntityResult('User\UserBundle\Entity\User', 'u');
 
    $rsm->addFieldResult('u', 'username', 'username');
    $rsm->addFieldResult('u', 'id', 'id');
    $rsm->addJoinedEntityResult('Property\ManagementBundle\Entity\Owner' , 'o', 'u', 'owners');
    $rsm->addFieldResult('o', 'o_id', 'id');
    $rsm->addFieldResult('o', 'o_name', 'name');
    $rsm->addJoinedEntityResult('Property\ManagementBundle\Entity\Property' , 'p', 'o', 'property');
    $rsm->addFieldResult('p', 'p_id', 'id');
    $rsm->addFieldResult('p', 'p_name', 'name');
    $rsm->addFieldResult('p', 'p_adress', 'adress');
    $rsm->addJoinedEntityResult('Property\ManagementBundle\Entity\Expenses' , 'e', 'p', 'expenses');
    $rsm->addFieldResult('e', 'e_id', 'id');
    $rsm->addFieldResult('e', 'e_name', 'name');
    $rsm->addFieldResult('e', 'e.price', 'price');
    $sql = "
            SELECT u.id,u.username,
            o.id as o_id,o.name as o_name,
            p.id as p_id,p.name as p_name,p.adress as p_adress,
            e.id as e_id,e.name as e_name,SUM(e.price) as SUMA
            FROM users u 
            INNER JOIN owner o ON u.id = o.user_id
            INNER JOIN property p ON o.id=p.owner_id
            LEFT JOIN expenses e ON p.id=e.property_id
            GROUP BY p_id
           ";
 
 
 
 
    $query= $this->_em->createNativeQuery(
      $sql, $rsm
    );   
 
//    $query->setParameter(1,$User);
 
    return $query->getArrayResult();
 
  }
}
[PHP] pobierz, plaintext