3

I'm using odm mongo doctrine and I have to document-classes

class Thing
{
/**
 * @MongoDB\Id
 */
protected $id;

 /**
  * @MongoDB\ReferenceOne(targetDocument="Bundle1:Other")
  */
protected $other;
}

and

class Other
{
/**
 * @MongoDB\Id
 */
protected $id;
}

so in the database a thing looks like : 

{
  "_id":ObjectId("43z758634875adf"),
  "other":ObjectId("38z287348d8se")
}

How can I now query for things where other is a given id ? 

    $dm=$this->mongo->getManager();
            $answers=$dm
                ->createQueryBuilder('Bundle1:Thing')
                ->field('other')->equals("ObjectId(516c0061975a299edc44b419)")  // <-- ?
                ->getQuery()
                ->execute()->count();

This produces a wrong mongo query

MongoDB query: {"find":true,"query":{"other":"ObjectId(516c0061975a299edc44b419)"},"fields":[],"db":"maself","collection":"thing"} [] []

When I use

->field('other')->equals("516c0061975a299edc44b419")

the query is also wrong

MongoDB query: {"find":true,"query":{"other":"516c0061975a299edc44b419"},"fields":[],"db":"maself","collection":"thing"} [] []

So how can I search for thing where other id equals an objectId ?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
john Smith
  • 17,409
  • 11
  • 76
  • 117

1 Answers1

6

Try 

->field('other')->equals(new \MongoId("516c0061975a299edc44b419"))

ObjectId is the internal type for Mongo, represented by \MongoId() in PHP

( But i have also answered in the first topic )

Fabien MEYNARD
  • 597
  • 4
  • 12