TYPO3 Core

I stumbled over this issue too (TYPO3 6.0). If not all records are translated and you use the paginatorWidget then item count doesn’t respect that there are untranslated objects. There are too many pagination links and there are not enough results to fill the page. Probably this is due to the fact that language and WS overlays right now can not be handled by the SQL query (asfaik the overlays are applied after the query execution; limit and offset are not applied to the final result but only to the initial query).

This is a major drawback because you first have to fetch all records, call toArray() and apply the pagination whereas the query should fetch only the items really needed... This will needless cost resources when you want to paginate hundreds or thousends of items.

That's exactly the way i solved this issue, by calling toArray() on all records and then count them since they are overplayed then. But this really cost lots of resources.

I think in 6.0 you can also change the query by setRespectSysLanguage and setSysLanguageUid. But in 1.3 setSysLanguageUid does not exist.

How would setRespectSysLanguage and setSysLanguageUid help in this case? The found translated objects are the right ones but they are not counted correctly. Would be cool to have a solution for that.

Rainer Becker wrote:

How would setRespectSysLanguage and setSysLanguageUid help in this case? The found translated objects are the right ones but they are not counted correctly. Would be cool to have a solution for that.

Yes and no: The translated are not the right ones. At beginning the are just all object with (sys_language_uid (0,-1)) in $objects, but when you render them they get overlayed so that it seems you have the right objects.

If i understood it right, you can deactivate the "AND sys_language_uid IN (0,-1)" in the query by setting setRespectSysLanguage=FALSE. Then you get all data even the translated ones.
If you now set setSysLanguageUid to the language you need you only get data in your language and then you can count them.

Without having tested:

$query = $this->createQuery();
$query->getQuerySettings()->setRespectSysLanguage(FALSE);
$query->getQuerySettings()->setSysLanguageUid($sys_uid);
$objects=$query->execute();
$count=$objects->count();

So $count would be the amount of data with the sys_language_uid=$sys_uid.

Any news here?