Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-63480

Course completion and Activity completion reports fail to filter UTF8 Firstname or Lastname

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 3.5.5, 3.6.3
    • 3.1.12, 3.5.1, 3.5.2
    • Reports
    • MOODLE_31_STABLE, MOODLE_35_STABLE
    • MOODLE_35_STABLE, MOODLE_36_STABLE
    • MDL-63480-master
    • Hide

      NOTE: This should be tested with mysql and mssql. Currently we do not support accent insensitive text comparisons in postgresql and oracle.

      1. Create several users.
        • make sure their firstname/lastname begins with a non-ASCII character (ex. Édward Johnson, John Öakes, Ían Ñelson).
      2. Create a Course.
      3. Enrol the created Users in the Course.
      4. Go to Course > Course administration > Reports > Course completion (/report/completion/index.php?course=COURSEID).
      5. Filter the users by first name and surname (try multiple variations).
        • make sure the filter works properly and filters out the non-ASCII names.
      1. Go to Course > Course administration > Reports > Activity completion (/report/progress/index.php?course=COURSEID).
      2. Filter the users by first name and surname (try multiple variations).
        • make sure the filter works properly and filters out the non-ASCII names.
      Show
      NOTE: This should be tested with mysql and mssql. Currently we do not support accent insensitive text comparisons in postgresql and oracle. Create several users. make sure their firstname/lastname begins with a non-ASCII character (ex. Édward Johnson, John Öakes, Ían Ñelson). Create a Course. Enrol the created Users in the Course. Go to Course > Course administration > Reports > Course completion (/report/completion/index.php?course=COURSEID). Filter the users by first name and surname (try multiple variations). make sure the filter works properly and filters out the non-ASCII names. Go to Course > Course administration > Reports > Activity completion (/report/progress/index.php?course=COURSEID). Filter the users by first name and surname (try multiple variations). make sure the filter works properly and filters out the non-ASCII names.

      When any participant has a non-ASCII first character in his/her Firstname or Lastname, he/she will be missed when filtering by first letter in his/her Firstname or Lastname. This happens from the Reports section of Course Administration (Course completion and Activity completion), but it works properly when a similar filtering system is applied from "Participants", or viewing attemps in a Quiz, etc.

      In Spain we have some firstnames and lastnames that begins with Á, É, Í, Ó, Ú, Ñ, etc. but also happens with Ö and other non-ASCII characters.

       

        1. Filter fails from Activity completion.PNG
          Filter fails from Activity completion.PNG
          12 kB
        2. Filter OK from Participants.PNG
          Filter OK from Participants.PNG
          24 kB
        3. MDL-63480.jpg
          MDL-63480.jpg
          31 kB

            Geshoski Mihail Geshoski
            jlmartin Jose Luis Martin Jimenez
            Glyn (Mathew) May Glyn (Mathew) May
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            Anna Carissa Sadia Anna Carissa Sadia
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours, 30 minutes
                2h 30m

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.