[FLOW3-general] Custom join with where

[Pankaj Lele]

Hi Rudy,

> 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?

There is definitely a very good way in Flow to write custom queries. 
What you have to do is add a new function inside your Repository class 
and use $this->createQuery() API.

Example from TYPO3.Blog - [1]

[1] 
http://git.typo3.org/FLOW3/Packages/TYPO3.Blog.git/blob/HEAD:/Classes/TYPO3/Blog/Domain/Repository/PostRepository.php 


-- 
Pankaj Lele
CTO - Lelesys, India
http://www.lelesys.com
Twitter: @pankajlele