[TYPO3-core] RFC: #11318: broken sorting of filemounts

[Rupert Germann]

hi georg,

the patch works, but there's one thing missing: the list view still shows
the filemounts ordered by uid.

suggestion: add 
'default_sortby' => 'ORDER BY title'
to TCA ctrl of sys_filemounts and use this value in the queries.

$GLOBALS['TCA']['sys_filemounts']['ctrl']['default_sortby']

(has to be appended directly to the where clause since it already
contains "ORDER BY") 


greets
rupert


georg kuehnberger wrote:
> RFC: #11318: broken sorting of filemounts
> 
> This is a SVN patch request.
> 
> Type: bugfix
> 
> BT Reference: http://bugs.typo3.org/view.php?id=11318
> 
> Branches: trunk & elder
> 
> Problem:
> - Given a Backend-User/Group has more than one filemount, those
> filemounts are displayed in broken/confusing order in the backend to the
> backend-user.
> - The TYPO3-Admin has no meaningfull chance to change the order of those
> filesmounts.
> - I percieve this as a bug, as the only workaround for defining a
> sort-order or filemounts would be fumbling with uid of the
> sys_filemounts in the DB. This is not feasable, and especially should
> not be reommended.
> 
> Info:
> class.t3lib_userauthgroup.php grabs the users accumulated filemounts,
> however with no sorting at all;
> that is, the filemounts are provided ordered by their UID, which however
> is neigther transparent nor changeable.
> Given that the sys_filemounts are only in the root-page, no manual
> sorting is possible, eigther. (pitty);
> 
> Solution:
> - Sort the filemounts alphabetically, by their title;
> - This approach matches the expected behaviour of Admins and Users, as
> its well known from filesystems/directories.
> - This allows for easily re-orderung via the backend, by simply renaming
> the given file-mounts.
> 
> Patch:
> - Added an "orderBy" statement to two selects in
> t3lib/class.t3lib_userauthgroup.php
> 
> This patch should also go into versions <= 4.3
> 
> Has patch: yes
> 
> regards georg