[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