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
![](https://secure.gravatar.com/avatar/1bf1a587ee566ff280782cf72d212b07?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)