[TYPO3-mvc] $query->statement('MYQUERY') doesn't count for <f:paginate />

Domi djgarms at gmail.com
Fri Mar 2 01:53:19 CET 2012


Hello and thanks for the answer. The reason I choosed the statement was, 
that I am working with an MN query. My previous statement was:

>       $query->statement('
> 	SELECT DISTINCT t.*
> 	FROM tx_dmftravelagent_domain_model_travel t
> 		INNER JOIN tx_dmftravelagent_travel_branch_mm mm ON mm.uid_local=t.uid
> 	WHERE t.travel_type=? AND mm.uid_foreign=? AND t.hidden=0 AND t.deleted=0
> 	', array($travelTypeUid, $branchUid));

I read in a previous post that MN relation doesn't work, but this works 
now for me:
$constraint = $query->logicalAnd($query->equals('travelType.uid', 
$travelTypeUid), $query->contains('branch', $branch));

With contains() the MN relation query seems to work fine.

Thanks for your responses!

Dominic


More information about the TYPO3-project-typo3v4mvc mailing list