Doctrine queryBuilder: return object not array

Question

I have this query created with doctrine querybuilder, the return i get is an array of arrays. I would like to get a return that is an array of objects, is this possible?

I know that normally Doctrine returns objects of an entity, bit since i have an inner join to get the name from another table it returns arrays.

Thanks in advance.

   $qb->select('u', 'h.name')
        ->from('AppBundle:UserHose', 'u')
        ->innerJoin('AppBundle:Hose', 'h', 'WITH', 'u.hoseId = h.id')
        ->where('u.userId = :userId')
        ->orderBy('u.id', 'DESC')
            ->setParameter('userId', $userId); 


    return $qb->getQuery()->getResult();

Alessandro Minoccheri · Accepted Answer · 2017-07-04 15:04:08Z

5

you can use this:

return $qb->getQuery()->getResult(Query::HYDRATE_ARRAY);

Or this:

return $qb->getQuery()->getArrayResult();

answered Jul 4, 2017 at 15:04

Alessandro Minoccheri

36.1k22 gold badges128 silver badges176 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mike Doe · Accepted Answer · 2018-03-02 11:42:49Z

3

This isn't possible this way. In other words, you are doing it wrong.

You are telling Doctrine to return a collection of collections containing an entity and a string so this is what you get. Doctrine won't make an object out of that since it does not know how to hydrate such result.

[
  [entity, string],
  [entity, string],
  ....
]

If you wish to receive a collection of objects only, you would need to create a new entity that has both fields (related entity and a string property), then use a ResultSet mapping to hydrate that.

edited Mar 2, 2018 at 11:42

answered Mar 2, 2018 at 11:37

Mike Doe

17.7k11 gold badges76 silver badges97 bronze badges

1 Comment

Zaid Mirza Over a year ago

Thanks for saving my day. I was stuck because of the select statement as it was returning an array of array instead of an array of entity objects.

zoore · Accepted Answer · 2018-03-02 11:21:04Z

if you want array of objects you have to set relation betwen Entities, and create a query by the owning side of relation.

example:

Tourney entity , Invite entity

Invite
    /**
     * @ORM\ManyToOne(targetEntity="Tourney", inversedBy="invites")
     */
    protected $tourneys;

Tourney
    /**

     * @ORM\OneToMany(targetEntity="Invite", mappedBy="tourneys", cascade={"persist", "remove"})
     * @ORM\JoinColumn(nullable=true, onDelete="CASCADE")
     */
    protected $invites;

now you have to make query to the owning side of relation (Invite) and it will be holding all your join object data with Tourneys in field $invites

and it gives you array of objects. based on your query

remeber of setter $invites as setInvites(Tourney $invites) and by inverse side of relation setTourneys(Invite $tourneys)

Dolly Aswin · Accepted Answer · 2017-07-04 15:06:40Z

-2

Just add \Doctrine\ORM\Query::HYDRATE_ARRAY on getResult() like this

$qb->select('u', 'h.name')
   ->from('AppBundle:UserHose', 'u')
   ->innerJoin('AppBundle:Hose', 'h', 'WITH', 'u.hoseId = h.id')
   ->where('u.userId = :userId')
   ->orderBy('u.id', 'DESC')
   ->setParameter('userId', $userId); 

return $qb->getQuery()->getResult(\Doctrine\ORM\Query::HYDRATE_ARRAY);

answered Jul 4, 2017 at 15:06

Dolly Aswin

2,8041 gold badge22 silver badges25 bronze badges

1 Comment

Cerad Over a year ago

Might want to read the question a bit closer. He is already getting an array result for some reason. He want an array of objects.

Collectives™ on Stack Overflow

Doctrine queryBuilder: return object not array

4 Answers 4

Comments

1 Comment

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

1 Comment

Linked

Related