I'm trying to join two tables called Users and Organizations (stored in MongoDB). The table users contains a foreign key (OrgId) that maps to the unique key in the Organizations table. When creating a new question where the two tables are joined, no results are returned.
However, when visualizing the users table, the orgId is clickable and show the correct Organization in a popup (see screenshot).
We were assuming the issue was that the field Users.OrgId is of the value type text/String and not ObjectId, but if that would be the case, clicking it shouldn't work either.
Any suggestions how we could proceed?