[SERVER-22781] Allow $lookup between ObjectId (_id.str) and string - MongoDB Jira

XML

Word

Printable

JSON

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"

}}

is duplicated by

SERVER-33171 Add number and objectID parsing conversions to $convert

related to

SERVER-24947 Need a type conversion mechanism for booleans, ISODates, ObjectID

Participants:: Alfonso Lentini [X], Ashraf Kamal, Asya Kamsky, Backlog - Query Team, Cade Embery, Charlie Swanson, Chema Roldán, Dan Cumings, David [X], David Storch, Hasan BUDAK [X], Jose Antonio Illescas Olmo, Luis Aldonza [X], mustapha, Nathan E Hoover, Patrick Nijkamp, Prashant Pokhriyal, Rafael da Silva Ferreira [X], srivani kambhampati, Ygor Lemos, Zhenghui Lee