TYPO3 Core

As a workaround this works, but obviously this is not respecting language config either and has other limitations...

[globalVar = GP:L > 0]
  dataProcessing.10 {
      table = pages
      pidInList.field = pages
      join = pages_language_overlay ON pages_language_overlay.pid = pages.uid
      where (
        pages_language_overlay.hidden = 0
        AND pages_language_overlay.deleted = 0
        AND pages_language_overlay.sys_language_uid = ###language###
        AND (pages_language_overlay.starttime < ###now### OR pages_language_overlay.starttime = 0)
        AND (pages_language_overlay.endtime > ###now### OR pages_language_overlay.endtime = 0)
      )
      selectFields = pages_language_overlay.*
      markers {
        language.data = GP:L
        now.data = date:U
      }
     as = pages
    }
[end]

Hello, the improvements do their job. In version 9.5.2-dev from today it works without setting the parameter "includeRecordsWithoutDefaultTranslation". The example listed under #2 is a part of our project and works now.
Thanks!

Are there any chances to get this running also under the current 8LTS (can reproduce the behaviour as described above in version 8.7.24)?

Fixing this in v8 is really really hard, I'd suggest to rather do a proper XCLASS of this for v8 in your project. The main issue here is that until v9, "pages" had their translations in a separate table, which made it almost impossible to fix all issues related to that, as this behavior does not comply with any other record type in TYPO3.

Benni Mack wrote:

We've made some improvements here now in the last weeks (9.5.2-dev), can you recheck this please?

dataProcessing.10 = TYPO3\CMS\Frontend\DataProcessing\DatabaseQueryProcessor
dataProcessing.10 {
table = pages
pidInList.field = pages
as = pages
}

Language fallback modes:

1. Fallback Type -> Strict: Show only translated content, based on overlays
works NOT as expected, shows non translated pages as well.

2. Fallback Type -> Free mode: Ignore translation and overlay concept, only show data from selected language
Works as expected, shows only translated pages.