MongoDB，查找属性ID等于记录ID的所有文档？
为此，请使用$where并与==进行比较。让我们创建一个包含文档的集合-
> db.demo69.insertOne(
... {
... "_id" : ObjectId("507c7f79bcf86cd7994f6c0e"),
... "Details" : {
...
... "id" : ObjectId("507c7f79bcf86cd7994f6c0e")
... }
... }
... );
{
"acknowledged" : true,
"insertedId" : ObjectId("507c7f79bcf86cd7994f6c0e")
}
> db.demo69.insertOne(
... {
... "_id" : ObjectId("507c7f79bcf86cd7994f6c0f"),
"Details" : {
... "id" :ObjectId("507c7f79bcf86cd7994f6c0a")
... }
... }
... );
{
"acknowledged" : true,
"insertedId" : ObjectId("507c7f79bcf86cd7994f6c0f")
}在find()方法的帮助下显示集合中的所有文档-
> db.demo69.find();
这将产生以下输出-
{ "_id" : ObjectId("507c7f79bcf86cd7994f6c0e"), "Details" : { "id" : ObjectId("507c7f79bcf86cd7994f6c0e") } }
{ "_id" : ObjectId("507c7f79bcf86cd7994f6c0f"), "Details" : { "id" : ObjectId("507c7f79bcf86cd7994f6c0a") } }以下是查询以查找属性ID等于记录ID的所有文档-
> db.demo69.find({
... $where: function(){
... return this._id.toString() == this.Details.id.toString();
... }
... }).pretty();这将产生以下输出-
{
"_id" : ObjectId("507c7f79bcf86cd7994f6c0e"),
"Details" : {
"id" : ObjectId("507c7f79bcf86cd7994f6c0e")
}
}