I have an entity Project with a M:M relation with User called Permissions. Permissions has user_id, project_id and role. I was able to list projects where user has a role.
Now, I want to list Exercises (1:M with Project on project_id property) where user has a role in the project they belong. I've tried several ways but I get Nest - missing FROM-clause entry for table "permissions".
Can this be achieved somehow?
I have an entity Project with a M:M relation with User called Permissions. Permissions has
user_id,project_idandrole. I was able to list projects where user has a role.Now, I want to list Exercises (1:M with Project on
project_idproperty) where user has a role in the project they belong. I've tried several ways but I getNest - missing FROM-clause entry for table "permissions".Can this be achieved somehow?