Table2GUI - Sorting

1 Requirements

The ILIAS society finances the Defaultsorting in the "Datacollections", see Data Collection - Default sort field.
 
The default sorting possibility works as expected. But other fields should sort by default ASC, too.
 
 
Why? just one exemple:
 
You have a datacollection with two fields:
a) Textfield: "Kategorie", where users choose the correct category
b) Textfield: "Literaturhinweis", where users write the bibliography
 
 
Actually, with the default-sorting "Kategorie" and ASCending-Order, ILIAS does not sort within the records "Grundlagen" or "Methodensammlung", or it sorts depending of the Creation date of the record?
 
Example of a possible sorting:
Grundlagen    Lehner, M. (2013). Viel Stoff – wenig Zeit; Wege aus der Vollständigkeitsfalle. Bern: Haupt Verlag. 4. Aufl.
Grundlagen    Gudjons, Herbert (2007): Frontalunterricht neu entdeckt. Bad Heilbrunn: Julius Klinkhardt. UTB.
Methodensammlungen    Weidenmann, Bernd (2008). Handbuch Active Training. Weinheim und Basel: Beltz. 2. Auflage
Methodensammlungen    Gross, Harald (2012): Munterbrechungen. Berlin: Gert Schilling Verlag. 2. Auflage
 
 
But ILIAS should sort the following way:
Grundlagen    Gudjons, Herbert (2007): Frontalunterricht neu entdeckt. Bad Heilbrunn: Julius Klinkhardt. UTB.
Grundlagen    Lehner, M. (2013). Viel Stoff – wenig Zeit; Wege aus der Vollständigkeitsfalle. Bern: Haupt Verlag. 4. Aufl.
Methodensammlungen    Gross, Harald (2012): Munterbrechungen. Berlin: Gert Schilling Verlag. 2. Auflage
Methodensammlungen    Weidenmann, Bernd (2008). Handbuch Active Training. Weinheim und Basel: Beltz. 2. Auflage
 
I already wrote a bug-report
http://www.ilias.de/mantis/view.php?id=12391
 
Martin said: "This is not possible with the ILIAS Table2GUI. It's a general ILIAS discussion."
 
 
Thanks for discussion this in JF

2 Additional Information

• Funding: Required
• Maintainer: Martin Studer
• Implementation of the feature is done by sr.solutions
• Contract settled: (fill in "Yes" if a contract is already settled, otherwise "No" )
• Tested by / status: (name, e-mail), (status information set after implementation)

3 Discussion

JF 6 Jan 2014: Currently (ILIAS 4.4) ILIAS supports only sorting by one column. A general support for sorting by two (or even more columns) would be quite "expensive". ilTable2GUI could support to store the two last clicked columns (and their order) in the database. ILIAS would use the default column as long as now first and/or second user column has been selected.
 
No column clicked: Sorting after default column(s).
One column clicked: Sorting after user column and (main) default column.
Second column clicked: Sorting after second and first column clicked by the user.
 
The arrow is only displayed for the main sorting order (default or last column clicked).
 
Default sorting is only used when a user never clicked a column. Sortings are already now stored persistent in ILIAS, this happens for all tables and supports usability in our view (e.g. admins that prefer a custom sorting for the user administration list).
 
We schedule this for 4.5.

4 Implementation

...