CODEWITHSUNDEEP
doctrinedql
Charles
Charles

Reputation: 11768

Doctrine where in with Doctrine_Query

is it possible to make :

$q->createQuery('q')
  ->whereIn('q.id', $q2)

Where $q2 is an other Doctrine_Query object. Because my subquery is complex and I don't want to write it in SQL...

Upvotes: 2

Views: 3679

Answers (2)

Jubayer Arefin
Jubayer Arefin

Reputation: 495

While using whereIn the parameter should be an array. You can use execute(array(), Doctrine_Core::HYDRATE_ARRAY) to return an array instead of an object.

Upvotes: 0

Imi Borbas
Imi Borbas

Reputation: 3703

Unfortunately, according to the Doctrine API documentation, you can't pass another query object to whereIn(), so you will have to fetch your ID-s beforehand and pass them in an array. Be careful though, because if you pass an empty array, then there will be NO FILTERING for those ID-s. In other words: it will return all rows present in your table, instead of none.

Upvotes: 2

Related Questions