I currently have two tables, one User and one Events. A user can be owner of the event but can also be invited. So a User can be owner of multiples Events but an Event can only have one owner. An Event can have multiple guests and a guest can be part of multiple Event.
In a list, I try to display the Events where a User is owner and where a user is a guest of the Event. SO I tried the following :
It doesn’t work, it displays all the result but after 0.5 second, the events where a user is a guest disappear.
I tried to display only the Events where the user is the owner, it works.
I tried to display only the Events where the user is a guest, it works.
But the combination of both doesn’t work.
Thanks for your reading