CODEWITHSUNDEEP
mongodb
jcollum
jcollum

Reputation: 46569

How do I search for an object by its ObjectId in the mongo console?

I've found this question answered for C# and Perl, but not in the native interface. I thought this would work:

db.theColl.find( { _id: ObjectId("4ecbe7f9e8c1c9092c000027") } )

The query returned no results. I found the 4ecbe7f9e8c1c9092c000027 by doing db.theColl.find() and grabbing an ObjectId. There are several thousand objects in that collection.

I've read all the pages that I could find on the mongodb.org website and didn't find it. Is this just a strange thing to do? It seems pretty normal to me.

Upvotes: 420

Views: 778808

Answers (13)

Tyler Brock
Tyler Brock

Reputation: 30136

Not strange at all, people do this all the time. Make sure the collection name is correct (case matters) and that the ObjectId is exact.

Documentation is here

> db.test.insertOne({x: 1})

> db.test.find()                                               // no criteria
{ "_id" : ObjectId("4ecc05e55dd98a436ddcc47c"), "x" : 1 }      

> db.test.find({"_id" : ObjectId("4ecc05e55dd98a436ddcc47c")}) // explicit
{ "_id" : ObjectId("4ecc05e55dd98a436ddcc47c"), "x" : 1 }

> db.test.find(ObjectId("4ecc05e55dd98a436ddcc47c"))           // shortcut
{ "_id" : ObjectId("4ecc05e55dd98a436ddcc47c"), "x" : 1 }

Upvotes: 632

user31782
user31782

Reputation: 7589

In the specific case of findOne, it seems like that mongoDb has slightly changed the ObjectId works. Following doesn't work:

let query = {_id: ObjectId(req.params.id)}; //Doesn't work
let result = await collection.findOne(query);

But the following works:

let query = {_id: new ObjectId(req.params.id)};
let result = await collection.findOne(query);

Upvotes: 1

user8234870
user8234870

Reputation:

For Pythonists:

import pymongo
from bson.objectid import ObjectId

...

for row in collectionName.find(
        {"_id" : ObjectId("63ae807ec4270c7a0b0f2c4f")}):
    print(row)

Upvotes: 0

Mustafa Deniz
Mustafa Deniz

Reputation: 1668

If you're using Node.js:

var ObjectId = require('mongodb').ObjectId; 
var id = req.params.gonderi_id;       
var o_id = new ObjectId(id);
db.test.find({_id:o_id})

Edit: corrected to new ObjectId(id), not new ObjectID(id)

Upvotes: 155

Saurabh
Saurabh

Reputation: 374

If you are working on the mongo shell, Please refer this : Answer from Tyler Brock

I wrote the answer if you are using mongodb using node.js

You don't need to convert the id into an ObjectId. Just use :

db.collection.findById('4ecbe7f9e8c1c9092c000027');

this collection method will automatically convert id into ObjectId.

On the other hand :

db.collection.findOne({"_id":'4ecbe7f9e8c1c9092c000027'}) doesn't work as expected. You've manually convert id into ObjectId.

That can be done like this :

let id = '58c85d1b7932a14c7a0a320d';

let o_id = new ObjectId(id);   // id as a string is passed

db.collection.findOne({"_id":o_id});

Upvotes: 23

Kushal Bhalaik
Kushal Bhalaik

Reputation: 3384

In MongoDB Stitch functions it can be done using BSON like below:

Use the ObjectId helper in the BSON utility package for this purpose like in the follwing example:

var id = "5bb9e9f84186b222c8901149";  
BSON.ObjectId(id);

Upvotes: 3

mina_anwer
mina_anwer

Reputation: 91

I think you better write something like this:

db.getCollection('Blog').find({"_id":ObjectId("58f6724e97990e9de4f17c23")})

Upvotes: 9

Miguel Peguero
Miguel Peguero

Reputation: 488

To use Objectid method you don't need to import it. It is already on the mongodb object.

var ObjectId = new db.ObjectId('58c85d1b7932a14c7a0a320d');
db.yourCollection.findOne({ _id: ObjectId }, function (err, info) {
   console.log(info)
});

Upvotes: -1

Oliver Wolf
Oliver Wolf

Reputation: 309

Once you opened the mongo CLI, connected and authorized on the right database.

The following example shows how to find the document with the _id=568c28fffc4be30d44d0398e from a collection called “products”:

db.products.find({"_id": ObjectId("568c28fffc4be30d44d0398e")})

Upvotes: 5

Patrick Graham
Patrick Graham

Reputation: 982

I just had this issue and was doing exactly as was documented and it still was not working.

Look at your error message and make sure you do not have any special characters copied in. I was getting the error 

SyntaxError: illegal character @(shell):1:43

When I went to character 43 it was just the start of my object ID, after the open quotes, exactly as I pasted it in. I put my cursor there and hit backspace nothing appeared to happen when it should have removed the open quote. I hit backspace again and it removed the open quote, then I put the quote back in and executed the query and it worked, despite looking exactly the same.

I was doing development in WebMatrix and copied the object id from the console. Whenever you copy from the console in WebMatrix you're likely to pick up some invisible characters that will cause errors.

Upvotes: 3

Shalabh Raizada
Shalabh Raizada

Reputation: 364

Simply do: 

db.getCollection('test').find('4ecbe7f9e8c1c9092c000027');

Upvotes: -8

Mohamed Abdullah J
Mohamed Abdullah J

Reputation: 359

You Have missed to insert Double Quotes. The Exact Query is 

db.theColl.find( { "_id": ObjectId("4ecbe7f9e8c1c9092c000027") } )

Upvotes: 24

MPlanchard
MPlanchard

Reputation: 1948

Even easier, especially with tab completion:

db.test.find(ObjectId('4ecc05e55dd98a436ddcc47c'))

Edit: also works with the findOne command for prettier output.

Upvotes: 110

Related Questions