Issue Bug Closed

#78295getQuery does not respect orderBy

Tobi Kretschmann 10/14/16, 14:29 updated 10/17/17, 23:16

Description

\TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer getQuery()

$this->getQueryConstraints($table, $conf); returns the correct $queryParts Array but the orderBy is not used in the resulting SQL Statement.

Because of this the content elements shown in frontend are not ordered anymore.

Used like this:

lib.dynamicContent = COA
lib.dynamicContent{
...

20 = CONTENT
20 {
    table = tt_content
    select {
        includeRecordsWithoutDefaultTranslation = 1
        where = colPos=0
        pidInList = this
        orderBy = sorting
    }
}

...
}

Reviews 1