Not able to join two tables

Hi,

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?

How are you building the question?

Using the editor (not a native query)