Gradebook's list of students sorting order doesn't respect white spaces
GENERAL
TESTING
GENERAL
TESTING
Description
Using java.text.Collator for ordering by lastnames makes a bad sorting order because Collator doesn't count the blank spaces, as reported in https://jira.sakaiproject.org/browse/KNL-873
Given two students, whose lastnames are "Martinez Torcal" and "Martin Troncoso", the logical alphabetical order is first "Martin Troncoso" and after "Martinez Torcal", just because the blank space is counted as a character.
However, in our Sakai 2.7.1 they are ordered just the opposite: first "Martinez Torcal" and after "Martin Troncoso". This issue happens in every tool of Sakai which uses Collator. And Gradebook is included.
I have made a patch for 2.7.1 using RuleBasedCollator class which fixes the problem, but I'm not sure if could affect the performance.
FYI, the problem described by Dave above has been fixed in SAK-23385.
David Haines April 18, 2013 at 1:17 PM
The approach used here allocates the collator in the compare method and that leads to unnecessarily high CPU usage when lots of data is involved. The allocation of the collator should be outside of the method. The implementation used in looks appropriate.
Using java.text.Collator for ordering by lastnames makes a bad sorting order because Collator doesn't count the blank spaces, as reported in https://jira.sakaiproject.org/browse/KNL-873
Given two students, whose lastnames are "Martinez Torcal" and "Martin Troncoso", the logical alphabetical order is first "Martin Troncoso" and after "Martinez Torcal", just because the blank space is counted as a character.
However, in our Sakai 2.7.1 they are ordered just the opposite: first "Martinez Torcal" and after "Martin Troncoso". This issue happens in every tool of Sakai which uses Collator. And Gradebook is included.
I have made a patch for 2.7.1 using RuleBasedCollator class which fixes the problem, but I'm not sure if could affect the performance.