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

Question

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

User · Answer

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.

User · Answer

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

User · Answer

To use Objectid method you don t need to import it  It is already on the mongodb object    x000D   x000D  var ObjectId   new db ObjectId  58c85d1b7932a14c7a0a320d    x000D  db yourCollection findOne    id  ObjectId    function  err  info    x000D     console log info  x000D      x000D                  x000D   x000D   x000D

User · Answer

I think you better write something like this   db getCollection  Blog   find    id  ObjectId  58f6724e97990e9de4f17c23

User · Answer

You Have missed to insert Double Quotes  The Exact Query is   db theColl find      id   ObjectId  4ecbe7f9e8c1c9092c000027

User · Answer

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

User · Answer

If you re using Node js    gt  var ObjectId   require  mongodb   ObjectId    gt  var id   req params gonderi id          gt  var o id   new ObjectId id    gt  db test find   id o id     Edit  corrected to new ObjectId id   not new ObjectID id

User · Answer

Simply do    db getCollection  test   find  4ecbe7f9e8c1c9092c000027

User · Answer

If you re using Node js   In that req user is ObjectId format   var mongoose   require  mongoose    var ObjectId   mongoose Schema Types ObjectId   function getUsers req  res      User findOne    id  req user     password  0               then data   gt                  res send data    g   exports getUsers   getUsers

User · Answer

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   gt  db test insert  x  1     gt  db test find                                                    no criteria     id    ObjectId  4ecc05e55dd98a436ddcc47c     x    1           gt  db test find    id    ObjectId  4ecc05e55dd98a436ddcc47c        explicit     id    ObjectId  4ecc05e55dd98a436ddcc47c     x    1     gt  db test find ObjectId  4ecc05e55dd98a436ddcc47c                 shortcut     id    ObjectId  4ecc05e55dd98a436ddcc47c     x    1

User · Answer

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

User · Answer

Even easier  especially with tab completion   db test find ObjectId  4ecc05e55dd98a436ddcc47c      Edit  also works with the findOne command for prettier output

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

Examples related to mongodb