[TYPO3-mvc] Count on Repository

[Henjo Hoeksma]

Hi Mark,

you can use a prepared statement for that using the statement() method[1].
Alternatively you could output the found objects uid into an $uids array
for example and write a 'normal' query method $query->in('uid',$uids)

[1]
http://forge.typo3.org/projects/typo3v4-mvc/wiki/Extbase__FLOW3_Security_Cookbook#Query-statement

Kind regards,

Henjo

Problems are small because we learned how to deal with them.
Problems are big because we need to learn how to deal with them.


On Fri, Jun 1, 2012 at 11:45 AM, Mark <mmarquis at digipets.de> wrote:

>
> Hi list,
>
> how is it possible to get the total count of a filtered query which is
> limited by limit and offset?
> I need the the total count of the filtered query in order to build a
> pagebrowser.
>
> Using raw SQL, i can use something like   "Select   SQL_CALC_FOUND_ROWS "
> but how can it be done with Extbase??
>
> Thanks & greetings
> Mark
>
> _______________________________________________
> TYPO3-project-typo3v4mvc mailing list
> TYPO3-project-typo3v4mvc at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc
>