Issue Bug Closed

#47688Sorting not respected for backend_layout and backend_layout_next_level dropdowns

Frans Saris 04/29/13, 11:54 updated 10/02/18, 12:13

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