Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-38966

Ordering by Lastname doesn't respect the blank spaces

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Non-Issue
    • Affects Version/s: 2.7.x
    • Fix Version/s: None
    • Labels:
    • Previous Issue Keys:
      KNL-873

      Description

      Given two students, whose lastnames are "Martinez Torcal" and "Martin Troncoso", these lastnames are written in the LASTNAME field of the SAKAI_USER table.

      Ordering in the database client, in excel or any other application, 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 with kernel 1.1.13 they are ordered at Site Info, Assignments, etc. just the opposite: first "Martinez Torcal" and after "Martin Troncoso". The same issue happens with LDAP users.

      I have searched at JIRA, but I haven't found any clue about this. Also, I have looked at BaseUserDirectoryService in the Kernel code but the getSortName() method doesn't seem to do nothing wrong.

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  daniel.merino Daniel Merino Echeverría
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Integration