mongodb query return simple array

Question

How can I make mongodb return results in a simple array?

Ex:

My first query:

$user_ids = $dm->createQueryBuilder('AcmeBundle:Users')
->hydrate(false)
->select('_id')
->getQuery()
->execute();

My second query:

$no_credit = $dm->getRepository('AcmeBundle:Places')
->createQueryBuilder('places')
->distinct('_id')
->field('visited.users')
->in($user_ids)
->getQuery()
->count();

How can I achieve this when the first query won't return an array of MongoID objects?

I must admit I do not symfony however I believe it returns an implmentation of MongoCursor as such getting the cursor object and doing iteratortoarray or something similar will solve the problem in a hackish way. — Sammaye
– Sammaye, Commented Jul 30, 2012 at 17:02
by "simple array" I mean an array(). Since that's how in() works: field('wtvr')->in(array(,,,)) . — localhost
– localhost, Commented Jul 30, 2012 at 17:09
Ok I see multiple problems here now. You will need to filter out your first query by iterating through it and forming the new array in which to do the in(). It is the only way due to how Mongo returns the results. — Sammaye
– Sammaye, Commented Jul 30, 2012 at 17:10
@Sammaye Please write your comment as an answer so I can accept it. — localhost
– localhost, Commented Jul 30, 2012 at 17:16

Sammaye · Accepted Answer · 2012-07-30 19:36:13Z

1

I must admit I do not symfony however I believe it returns an implmentation of MongoCursor as such getting the cursor object and doing iteratortoarray or something similar will solve the problem in a hackish way.

answered Jul 30, 2012 at 19:36

Sammaye

44k7 gold badges110 silver badges149 bronze badges

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

1 Comment

localhost Over a year ago

While this didn't exactly solve my problem, it does solve similar issues. By doing array_keys() I can get the "raw data" that is stored on the results. But as your second comment suggests, "You will need to filter out your first query by iterating through it and forming the new array in which to do the in()".

Collectives™ on Stack Overflow

mongodb query return simple array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related