I'm building a client CRM with a separate events table that is connected to each client. I would like to see the next event I have planned for each client, in the client table.

I use the related due date, but this doesn't allow me to filter for only open tasks. If I choose min, that returns the first event. If I choose max, that returns the last event date.

However I have many events planned in between. I need the ability to filter for only open tickets.