Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-22781

Allow $lookup between ObjectId (_id.str) and string

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Minor - P4
    • Resolution: Duplicate
    • Affects Version/s: 3.2.1
    • Fix Version/s: None
    • Component/s: Aggregation Framework
    • Labels:

      Description

      this feature allows lookup using _id.str

      company: {_id: { $oid: "..."}, countryId: "566eb3c704c7b31facbb0007"}
      		 
      country: { _id: { $oid: "566eb3c704c7b31facbb0007", name:"..."} 
       
      		 
      { $lookup: {
      		 
             from: "country",
      		 
             localField: "countryId",    <= it's a string field
      		 
             foreignField: "_id.str",    <= using string representation of id
      		 
             as: "country"
      		 
      }}

        Attachments

          Issue Links

          is duplicated by

          Task - A task that needs to be done. SERVER-33171 Add number and objectID parsing conversions to $convert

          • Major - P3 - Major loss of function.
          • Closed
          related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-24947 Need a type conversion mechanism for booleans, ISODates, ObjectID

          • Major - P3 - Major loss of function.
          • Closed

            Activity

              People

              • Votes:
                25 Vote for this issue
                Watchers:
                41 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: