exclude fields in $lookup aggregation

by

In mongodb 3.6 you can use projection ($project) inside $lookup pipeline… Something like this

db.User.aggregate([
  { "$match": { "userID":"1" }},
  { "$lookup":{
    "from": "Skill",
    "pipeline": [
      { "$match": { "languageID": "hindiid", "skillID": { "$in": [ "javaid","pythonid" ] }}},
      { "$project": { "_id": 0 }}
    ],
    "as": "skills"
  }}
])

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. MongoDB: Combine data from multiple collections into one..how?
  5. Multiple join conditions using the $lookup operator
  6. Conditional $sum in MongoDB
  7. Return only matched sub-document elements within a nested array
  8. Converting string to date in mongodb
  9. MongoDB Full and Partial Text Search
  10. Mongodb Join on _id field from String to ObjectId
  11. MongoDB aggregation comparison: group(), $group and MapReduce
  12. Add some kind of row number to a mongodb aggregate command / pipeline
  13. Multiple Counts with single query in mongodb
  14. Mongo sort on a calculated condition
  15. MongoDB sort documents by array elements
  16. How to return array of string with mongodb aggregation
  17. MongoDB: Calculate dwell time between every status value change
  18. MongoDB: how to parse date in 3.6 mongoDb version?
  19. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  20. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  21. convert iso date to timestamp in mongo query
  22. Remove Duplicates from MongoDB
  23. Using $slice operator to get last element of array
  24. Mongodb aggregation $group, restrict length of array
  25. How to access overall document count during arithmetic aggregation expression
  26. Geospatial $near within current document field value
  27. Mongodb aggregation pipeline how to limit a group push
  28. $project in $lookup mongodb
  29. Return actual type of a field in MongoDB
  30. Return the last “true” value for each group

Leave a Comment