How to query in mongodb with condition as regex matching ObjectId?

Question

For some reason, I need to look up a collection with its entry ObjectId field. For example, how should I put up a query dictionary in the find() method, so that I get all entry with hex ObjectId matching '5c.*'.

> db.demoCommentCollection.find()
{
        "_id" : ObjectId("5c7fec06d2ea12b0cdc7a490"),
        "comment" : "Hi, I'm Al and I love Object Rocket and I love comments."
}
{
        "_id" : ObjectId("4db1ec06d2ea12b0cdc7a491"),
        "comment" : "This is Cameron. I enjoyed reading your Object Rocket tutorials."
}
{
        "_id" : ObjectId("5c7fec06d2ea12b0cdc7a492"),
        "userId" : 2,
        "comment" : "I'm Betty. This is my first comment on the site."
}
> db.demoCommentCollection.find({/* some query dict to query objectid hex start with '5c' */})
{
        "_id" : ObjectId("5c7fec06d2ea12b0cdc7a492"),
        "comment" : "I'm Betty. This is my first comment on the site."
}
{
        "_id" : ObjectId("5c7fec06d2ea12b0cdc7a490"),
        "comment" : "Hi, I'm Al and I love Object Rocket and I love comments."
}

Belly Buster · Accepted Answer · 2020-11-12 19:57:12Z

1

Similar to How to find document by parts of ObjectId? you can use $where in pymongo.

db.mycollection.find({'$where': 'this._id.str.match(/^5c/)'})

answered Nov 12, 2020 at 19:57

Belly Buster

8,9142 gold badges12 silver badges25 bronze badges

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

2 Comments

Zhang Xinye Over a year ago

Does it have injection risk?

Belly Buster Over a year ago

Certainly it is a higher risk, yes.

Collectives™ on Stack Overflow

How to query in mongodb with condition as regex matching ObjectId?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related