I’ve ran into an issue which I can’t figure out how to solve.
My collections are setup like this:
- Users - Many to Many relationship with clubs. Many to one relationship with membership
- Clubs - Many to Many relationship with Users. Many to one relationship with membership
- Membership - One to Many relationship to Users and Clubs
So I have a basic “profile” screen with a list showing “Logged in Users Clubs”, that works fine. However in each list item, there is a button linking to a membership page, this page is supposed to show you your paid membership details in that specific club (From membership collection).
However I can’t get the filtering right. Either I get all memberships of current user, or all memberships of the selected club.
In the membership page in filter I need to first filter out the logged in users memberships, and then match it to the selected club.
Anyone have any idea?