have a question about left join in doctrine in Symfony 2.7.
Example code:
public function test($id, $offset, $limit)
{
$build = $this->createQueryBuilder('building');
$build
->addSelect('users', 'numbers')
->join('building.users', 'users')
->leftJoin('building.numbers', 'numbers')
->where('building.id = :id')
->setParameter('id', $id);
$paginator = new Paginator($build->getQuery(), $fetchJoinCollection = true);
$result = $paginator->getQuery()
->setFirstResult($offset)
->setMaxResults($limit)
->getResult();
return $result;
}
My question now is how could we implement that the ->leftJoin('building.numbers', 'numbers') only return MAX 1 result.
Thanks!
Doctrine orm: 2.2.3, Symfony version: 2.7
What I have tried:
public function test($id, $offset, $limit)
{
$build = $this->createQueryBuilder('building');
$build
->addSelect('users', 'numbers')
->join('building.users', 'users')
->leftJoin('building.numbers', 'numbers')
->where('building.id = :id')
->setParameter('id', $id);
$paginator = new Paginator($build->getQuery(), $fetchJoinCollection = true);
$result = $paginator->getQuery()
->setFirstResult($offset)
->setMaxResults($limit)
->getResult();
return $result;
}