[TYPO3-mvc] Query Statement and paginator

[christian oettinger]

Hi list,

I need some help in understanding a problem of mine:
We have a query statement (see below) in repository. It works as 
expected. However I can not use paginator with the objects created by 
this query: It will show all results on each page.


can anyone see a reason for that?
thanks in advance
christian (oe)





$query = $this->createQuery();
$query->statement('
       SELECT *,
         MATCH (text)
           AGAINST('.$searchstring1.' IN BOOLEAN MODE) AS mtch1,
         MATCH (text)
           AGAINST('.$searchstring2.') AS mtch2
       FROM tx_arztcme_domain_model_training
       WHERE
         (available_until >= 1
           AND available_until >= '.$date.'
           )
         OR (available_until = 0
           AND crdate >= ('.$date.'-60*60*24*365)
           )
       HAVING mtch1 > 0 OR
       vnr LIKE "'.$searchword.'"
       ORDER BY mtch2 DESC, crdate DESC
     ');
return $query->execute();