Lookup fields with String and ObjectId on either side
We are evaluating Atlas Charts for our business analytics. Right now it is not possible to create a lookup in the UI from a String to an ObjectId field. Based on this answer (https://www.mongodb.com/community/forums/t/mongodb-charts-lookup-field/208617/4) it is possible by adding a small aggregation stage, but we plan on giving this to team members who do not know how to write aggregation pipelines.
1
vote
Florian
shared this idea