How can I select specific Columns with createQueryBuilder in Doctrine ORM?
Try following,
$fields = array('d.id', 'd.name', 'o.id');//$fields = 'partial d.{id, name}, partial o.{id}'; //if you want to get entity object$query = $this->getEntityManager()->createQueryBuilder();$query ->select($fields) ->from('AcmeBundle:Demo', 'd') ->leftjoin('d.otherEntity', 'o');$query->setMaxResults(10);$results = $query->getQuery()->getResult();