Description of problem: Current CMS 6 does not display sort items in any intuitive manner. Following modifications allow to : 1. display items within a folder in an alphabetical order, sorted by name, case insensitive. (admin ui : content section page, 'browse' tab : right part : paginated display) 2. display folder tree in an alphabetical order, sorted by label, case insensitive. (admin ui : content section page, 'browse' tab : left part) Code modifications for point 1 (in CMS) : in com.arsdigita.cms.ui.folder.FolderBrowser.getTotalSize(Paginator, PageState) : replace line : itemColl.addOrder("item.name"); by line : itemColl.setOrder("lower(item.name)"); Note : original line resulted in a query that sorts the following way : order by st_.is_folder desc, st_.item_id desc, st_.name Code modifications for point 2 (CMS) : in pdl/com/arsdigita/content-section/Folder-queries.ora.pdl : in query getSubFolders, after line : group by f.label, f.folder_id add : order by lower(f.label) in query getSubFoldersWithPermissions, after line : group by f.label, f.folder_id add : order by lower(f.label) Do the same also for postgre.
Closing old tickets