I have 3 entity classes:
Event - String title Calendar - List<Event> @OneToMany SharedCalendar extends Calendar - Calendar original
Now I want to retrieve all events from a specific calendar by its id like:
SELECT event FROM Calendar c1, SharedCalendar c2 INNER JOIN c1.events AS event INNER JOIN c2.original.events AS event WHERE c1.id=?1 OR c2.id=?1
Unfortunately this query returns no events at all, removing the SharedCalendar from the query works as expected. How can I achieve this?
Thanks for your support.