#47688Sorting not respected for backend_layout and backend_layout_next_level dropdowns
Description
Backend_layouts have a sortBy field but the pages TCA doesn’t respect this for the backend_layout and backend_layout_next_level field.
To fix this add ORDER BY to the ‘foreign_table_where’ field:
change for both field:
'foreign_table_where' => 'AND ( ( ###PAGE_TSCONFIG_ID### = 0 AND ###STORAGE_PID### = 0 ) OR ( backend_layout.pid = ###PAGE_TSCONFIG_ID### OR backend_layout.pid = ###STORAGE_PID### ) OR ( ###PAGE_TSCONFIG_ID### = 0 AND backend_layout.pid = ###THIS_UID### ) ) AND backend_layout.hidden = 0',
in:
'foreign_table_where' => 'AND ( ( ###PAGE_TSCONFIG_ID### = 0 AND ###STORAGE_PID### = 0 ) OR ( backend_layout.pid = ###PAGE_TSCONFIG_ID### OR backend_layout.pid = ###STORAGE_PID### ) OR ( ###PAGE_TSCONFIG_ID### = 0 AND backend_layout.pid = ###THIS_UID### ) ) AND backend_layout.hidden = 0 ORDER BY backend_layout.sorting',
Reviews 5
- TYPO3_4-7 20713[BUGFIX] Sorting not respected for backend layout dropdowns
- TYPO3_6-1 20710[BUGFIX] Sorting not respected for backend layout dropdowns
- main 20444[BUGFIX] Sorting not respected for backend layout dropdowns
- TYPO3_4-5 20714[BUGFIX] Sorting not respected for backend layout dropdowns
- TYPO3_6-0 20712[BUGFIX] Sorting not respected for backend layout dropdowns