Mongodb Join on _id field from String to ObjectId

by

You can use $toObjectId aggregation from mongodb 4.0 which converts String id to ObjectId

db.role.aggregate([
  { "$lookup": {
    "from": "user",
    "let": { "userId": "$_id" },
    "pipeline": [
      { "$addFields": { "userId": { "$toObjectId": "$userId" }}},
      { "$match": { "$expr": { "$eq": [ "$userId", "$$userId" ] } } }
    ],
    "as": "output"
  }}
])

Or you can use $toString aggregation from mongodb 4.0 which converts ObjectId to String 

db.role.aggregate([
  { "$addFields": { "userId": { "$toString": "$_id" }}},
  { "$lookup": {
    "from": "user",
    "localField": "userId",
    "foreignField": "userId",
    "as": "output"
  }}
])

More Related Contents:

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

Leave a Comment