The relationship diagram in the OData data dictionary contains relationships which are non-active relationships (shown as dotted lines). How do we make use of these relationships?
This is a common occurrence where learners and tutors/administrators are referenced within the same Aptem OData table. All users [learners, tutors, admins, employer users] are referenced in the key ‘Users’ table.
However, only one join can be made against the ‘Id’ field on the Users table. For example: Joining both RecipentId and SenderId from Message table to User[Id] will result in multiple joins that result in a filter that excludes all records.
The solution is to create multiple copies of the Users table but filtered for each of the different user types ie user, admin, employer, and separately connectly these tables to the other table.
This situation can occur where different types of users are referenced in the same table. For example: LearnerId, AdminId, ComponentOwnerId, OwnerId, AuthorId,