How do I rename fields when performing search/projection in MongoDB?

by

So basically using .aggregate() instead of .find():

db.tweets.aggregate([
    { "$project": {
        "_id": 0,
        "coords": "$level1.level2.coordinates"
    }}
])

And that gives you the result that you want.

MongoDB 2.6 and above versions return a “cursor” just like find does.

See $project and other aggregation framework operators for more details.

For most cases you should simply rename the fields as returned from .find() when processing the cursor. For JavaScript as an example, you can use .map() to do this.

From the shell:

db.tweets.find({},{'level1.level2.coordinates': 1, _id:0}).map( doc => {
  doc.coords = doc['level1']['level2'].coordinates;
  delete doc['level1'];
  return doc;
})

Or more inline:

db.tweets.find({},{'level1.level2.coordinates': 1, _id:0}).map( doc => 
  ({ coords: doc['level1']['level2'].coordinates })
)

This avoids any additional overhead on the server and should be used in such cases where the additional processing overhead would outweigh the gain of actual reduction in size of the data retrieved. In this case ( and most ) it would be minimal and therefore better to re-process the cursor result to restructure.

More Related Contents:

  1. Retrieve only the queried element in an object array in MongoDB collection
  2. Update MongoDB field using value of another field
  3. Does MongoDB’s $in clause guarantee order
  4. $lookup on ObjectId’s in an array
  5. MongoDB: Combine data from multiple collections into one..how?
  6. Return only matched sub-document elements within a nested array
  7. Converting string to date in mongodb
  8. Check if every element in array matches condition
  9. MongoDB nested lookup with 3 levels
  10. MongoDB Full and Partial Text Search
  11. Matching ObjectId to String for $graphLookup
  12. Mongodb Join on _id field from String to ObjectId
  13. Mongodb aggregation lookup with conditions
  14. How to get back the Original document back after aggregation
  15. Mongo sort on a calculated condition
  16. MongoDB lookup when foreign field is an array of objects
  17. MongoDB: Calculate dwell time between every status value change
  18. MongoDB: how to parse date in 3.6 mongoDb version?
  19. Search on multiple collections in MongoDB
  20. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  21. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  22. convert iso date to timestamp in mongo query
  23. Remove Duplicates from MongoDB
  24. Using $slice operator to get last element of array
  25. How to access overall document count during arithmetic aggregation expression
  26. count array occurrences across all documents with mongo
  27. Mongodb concat int and string
  28. Return actual type of a field in MongoDB
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. MongoDB aggregate within daily grouping [duplicate]

Leave a Comment