I have a many-to-may relationship between the entities events and users. The pivot table stores only records of users who participate in an event. However, in the relation manage list view I would like to display all events even those for which the user has no record in the pivot table. If I should do this in pure sql, I would use outer join. Is it possible to define something like this in config_relation.yaml
That’s not really how a pivot table works. I think perhaps you could check if the pivot is empty, and use this condition to display a list of all events instead.
I solved this using a raw sql statement with left outer joins. Thanks to the OctoberCMS concept, there is always a way to a solution. Thank you!