[FLOW3-general] Custom join with where

[Rudy Gnodde]

Hello all,

I have three models: Agenda, AgendaPerson and Person. Person extends the 
default \TYPO3\Party\Domain\Model\Person model. Agenda contains (among 
other fields) a date. AgendaPerson is used to set which person is 
attending the meeting the agenda is for and what role(s) that person has 
(manager, chairman, secretary, etc).

The way I have it now, I can get the logged in Person object, get the 
AgendaPerson objects connected to that Person and get the Agenda's that 
person is attending that way.

What I want to be able to do is get all Agenda objects the logged in 
Person has a manager role in where the date of the Agenda is larger than 
the current date.

In ExtBase I would just add a function in the AgendaRepository create a 
new query and execute a custom query using the statement method. However 
in Flow there is no statement method, so I can't do a custom query. I 
can understand this, since ideally you don't want to do anything 
directly on the database. But is there any way to do this without having 
to loop through a lot of AgendaUsers and Agendas I don't need in PHP?

Thanks,

Rudy