Doctrine MongoDB find by id

2020-03-06 04:22发布

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 ?

1条回答
叛逆
2楼-- · 2020-03-06 04:46

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 )

查看更多
登录 后发表回答