Issue Bug Closed

#82263Sys_file_reference child Objects are not sorted by "foreign_sortby"

Anonymous 08/31/17, 18:45 updated 06/07/19, 16:00

Description

Creating a column for Sys File Reference like this

'downloads' => [
            'label' => $languagePath . 'download.downloads',
            'l10n_mode' => 'noCopy',
            'config' => \TYPO3\CMS\Core\Utility\ExtensionManagementUtility::getFileFieldTCAConfig('downloads',
                [
                    'foreign_types' => [
                        '0' => [
                            'showitem' => '
                            --palette--;LLL:EXT:lang/Resources/Private/Language/locallang_tca.xlf:sys_file_reference.imageoverlayPalette;imageoverlayPalette,
                            --palette--;;filePalette'
                        ],
                        \TYPO3\CMS\Core\Resource\File::FILETYPE_TEXT => [
                            'showitem' => '
                            --palette--;LLL:EXT:lang/Resources/Private/Language/locallang_tca.xlf:sys_file_reference.imageoverlayPalette;imageoverlayPalette,
                            --palette--;;filePalette'
                        ],
                        \TYPO3\CMS\Core\Resource\File::FILETYPE_IMAGE => [
                            'showitem' => '
                            --palette--;LLL:EXT:lang/Resources/Private/Language/locallang_tca.xlf:sys_file_reference.imageoverlayPalette;imageoverlayPalette,
                            --palette--;;filePalette'
                        ],
                        \TYPO3\CMS\Core\Resource\File::FILETYPE_AUDIO => [
                            'showitem' => '
                            --palette--;LLL:EXT:lang/Resources/Private/Language/locallang_tca.xlf:sys_file_reference.audioOverlayPalette;audioOverlayPalette,
                            --palette--;;filePalette'
                        ],
                        \TYPO3\CMS\Core\Resource\File::FILETYPE_VIDEO => [
                            'showitem' => '
                            --palette--;LLL:EXT:lang/Resources/Private/Language/locallang_tca.xlf:sys_file_reference.videoOverlayPalette;videoOverlayPalette,
                            --palette--;;filePalette'
                        ],
                        \TYPO3\CMS\Core\Resource\File::FILETYPE_APPLICATION => [
                            'showitem' => '
                            --palette--;LLL:EXT:lang/Resources/Private/Language/locallang_tca.xlf:sys_file_reference.imageoverlayPalette;imageoverlayPalette,
                            --palette--;;filePalette'
                        ]
                    ],
                    'minitems' => 1
                ]
            ),
        ],

Does not sort the downloads when accessing the Parent via the controller or fluid.

Considering a simple Element Download with name and files. Files is a TCA config like above.
Adding 3-4 Files in the backend and change the order of them.
Use $this->downloadRepository->findAll() and iterate in fluid over “files” does not show them like sorted in the backend.
The SQL Query does not contain an ORDER BY part so the files are Ordered by the uid instead of the sorting field.

Changing ‘foreign_sortby’ to something else does not help, because the query is always called without any ORDER BY

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.