mongodb get _id as string in find query

by

MongoDB 4.0 adds the $convert aggregation operator and the $toString alias which allows you to do exactly that:

db.getCollection('example').aggregate([
  { "$match": { "example":1 } },
  { "$project": { "_id": { "$toString": "$_id" } } }
])

A main usage would most likely be though to use the _id value as a “key” in a document.

db.getCollection('example').insertOne({ "a": 1, "b": 2 })

db.getCollection('example').aggregate([
  { "$replaceRoot": {
    "newRoot": {
      "$arrayToObject": [
        [{ 
          "k": { "$toString": "$_id" },
          "v": {
            "$arrayToObject": {
              "$filter": {
                "input": { "$objectToArray": "$$ROOT" },
                "cond": { "$ne": ["$$this.k", "_id"] }
              }
            }
          }
        }] 
      ]
    }
  }}
])

Which would return:

{ 
  "5b06973e7f859c325db150fd" : { "a" : 1, "b" : 2 }
}

Which clearly shows the string, as does the other example.

Generally though there is usually a way to do “transforms” on the cursor as documents are returned from the server. This is usually a good thing since an ObjectId is a 12-byte binary representation as opposed to a 24 character hex “string” which takes a lot more space.

The shell has a .map() method

db.getCollection('example').find().map(d => Object.assign(d, { _id: d._id.valueOf() }) )

And NodeJS has a Cursor.map() which can do much the same thing:

let cursor = db.collection('example').find()
    .map(( _id, ...d }) => ({ _id: _id.toString(), ...d }));

while ( await cursor.hasNext() ) {
  let doc = cursor.next();
  // do something
})

And the same method exists in other drivers as well ( just not PHP ), or you can just iterate the cursor and transform the content as is more likely the best thing to do.

In fact, whole cursor results can be reduced into a single object with great ease by simply adding to any cursor returning statement, when working in the shell

.toArray().reduce((o,e) => { 
  var _id = e._id;
  delete e._id;
  return Object.assign(o, { [_id]: e })
},{ })

Or for full ES6 JavaScript supporting environments like nodejs:

.toArray().reduce((o,({ _id, ...e })) =>  ({ ...o, [_id]: e }),{ })

Really simple stuff without the complexity of what needs to process in the aggregation framework. And very possible in any language by much the same means.

More Related Contents:

  1. MongoDB Duplicate Documents even after adding unique key
  2. Calculate skip value for given record for sorted paging
  3. MongoDB aggregate query using PHP driver
  4. Update MongoDB field using value of another field
  5. Does MongoDB’s $in clause guarantee order
  6. $lookup on ObjectId’s in an array
  7. Return only matched sub-document elements within a nested array
  8. Converting string to date in mongodb
  9. MongoDB Regex Search on Integer Value
  10. Check if every element in array matches condition
  11. MongoDB nested lookup with 3 levels
  12. Aggregation filter after $lookup
  13. MongoDB Full and Partial Text Search
  14. Matching ObjectId to String for $graphLookup
  15. Mongodb Join on _id field from String to ObjectId
  16. MongoDB: Fatal error: Class ‘MongoClient’ not found
  17. Mongodb aggregation lookup with conditions
  18. How to get back the Original document back after aggregation
  19. Class ‘MongoClient’ not found
  20. PHP Startup Unable to load dynamic library php_mongo.dll
  21. Fatal Error – ‘Mongo’ class not found
  22. MongoDB lookup when foreign field is an array of objects
  23. Search on multiple collections in MongoDB
  24. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  25. Remove Duplicates from MongoDB
  26. Fatal error: Class ‘MongoDB\Driver\Manager’ not found
  27. MongoDB PHP UTF-8 problems
  28. count array occurrences across all documents with mongo
  29. $project in $lookup mongodb
  30. Return actual type of a field in MongoDB

Leave a Comment