$project in $lookup mongodb

by

You can use $lookup 3.6 syntax to $project the fields inside the $lookup pipeline

User.aggregate([
  { "$lookup": {
    "from": "schedules",
    "let": { "id": "$_id.phone" },
    "pipeline": [
      { "$match": { "$expr": { "$eq": ["$customer.phone", "$$id"] }}},
      { "$project": { "scheduleStart": 1, "scheduleEnd": 1 }}
    ],
    "as": "user_detail"
  }}
])

More Related Contents:

  1. Does MongoDB’s $in clause guarantee order
  2. Moongoose aggregate $match does not match id’s
  3. MongoDB nested lookup with 3 levels
  4. Mongodb Join on _id field from String to ObjectId
  5. How to return just the nested documents of an array from all documents
  6. MongoDB: Calculate dwell time between every status value change
  7. MongoDB: how to parse date in 3.6 mongoDb version?
  8. Mongodb aggregation $group, restrict length of array
  9. Mongodb, aggregate query with $lookup
  10. Retrieve only the queried element in an object array in MongoDB collection
  11. Update MongoDB field using value of another field
  12. $lookup on ObjectId’s in an array
  13. Return only matched sub-document elements within a nested array
  14. Converting string to date in mongodb
  15. Check if every element in array matches condition
  16. MongoError: The ‘cursor’ option is required, except for aggregate with the explain argument
  17. MongoDB Full and Partial Text Search
  18. Matching ObjectId to String for $graphLookup
  19. Mongodb aggregation lookup with conditions
  20. How to get back the Original document back after aggregation
  21. Mongo sort on a calculated condition
  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. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  26. How to access overall document count during arithmetic aggregation expression
  27. count array occurrences across all documents with mongo
  28. mongodb aggregate query isn’t returning proper sum on using $sum
  29. Return the last “true” value for each group
  30. MongoDB aggregate within daily grouping [duplicate]

Leave a Comment