If i have a mongo document id as a string how do I query for it as an _id?

Question

If i have a mongo document id as a string how do I query for it as an _id?

Will it work correctly to do .find({_id:'stringID'}) or do I need to convert it to a bson object first?

Answer 1

If your _id values are strings, you may query them just like any other field. (Just remember, if you are setting custom values for _id, they must be kept unique, or you will get a duplicate key error. )

Here is an example in the Mongo JS Shell:

> db.test.insert({_id:"stringID1"})
> db.test.insert({_id:"stringID2"})
> db.test.insert({_id:"stringID3"})
> db.test.find({_id:"stringID1"})
{ "_id" : "stringID1" }
> 

Is this what you were looking for? I hope I did not misunderstand your question!

Answer 2

Mongoose auto casts the string _id to ObjectId when you use findByID, so you can query using the string _id.

Also remember that any input coming into your API from req.body or req.params will all be type string so you will need to type cast if needed..., but as mentioned, mongoose does that for you so you can just leave _id in the string format it comes in as.