Symfony2 Select one column in doctrine

Lughino picture Lughino · Feb 24, 2013 · Viewed 32.2k times · Source

I'm trying to refine the query trying to select fewer possible values ​​.. For example I have an entity "Anagrafic" that contains your name, address, city, etc., and a form where I want to change only one of these fields, such as address. I have created this query:

//AnagraficRepository
public function findAddress($Id)
{
     $qb = $this->createQueryBuilder('r')
             ->select('r.address')
             ->where('r.id = :id')
             ->setParameter('id', $Id)
             ->getQuery();

     return $qb->getResult();
}

there is something wrong with this query because I do not return any value, but if I do the query normally:

//Controller
$entity = $em->getRepository('MyBusinessBundle:Anagrafic')->find($id);

Return the right value. How do I do a query selecting only one column?

Answer

Jovan Perovic picture Jovan Perovic · Feb 24, 2013

Since you are requesting single column of each record you are bound to expect an array. That being said you should replace getResult with getArrayResult() because you can't enforce object hydration:

$data = $qb->getArrayResult();
Now, you have structure:
    $data[0]['address']
    $data[1]['address']
    ....

Hope this helps.

As for the discussion about performance in comments I generally agree with you for not wanting all 30 column fetch every time. However, in that case, you should consider writing named queries in order to minimize impact if you database ever gets altered.