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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.1.12, 3.5.1, 3.5.2
    • Fix Version/s: 3.5.5, 3.6.3
    • Component/s: Reports
    • Labels:
    • Testing Instructions:
      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.
    • Affected Branches:
      MOODLE_31_STABLE, MOODLE_35_STABLE
    • Fixed Branches:
      MOODLE_35_STABLE, MOODLE_36_STABLE
    • Pull from Repository:
    • Pull 3.5 Branch:
    • Pull 3.5 Diff URL:
    • Pull Master Branch:
      MDL-63480-master
    • Pull Master Diff URL:

      Description

      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.

       

        Attachments

          Issue Links

          Testing discovered

          Improvement - An enhancement to an existing Moodle feature. MDL-64688 Add support to case-insensitive searches regardless of the database engine

          • Minor - Minor loss of function where workaround is possible
          • Open

            Activity

              People

              Assignee:
              Geshoski Mihail Geshoski
              Reporter:
              jlmartin Jose Luis Martin Jimenez
              Peer reviewer:
              Mathew May
              Integrator:
              Sara Arjona (@sarjona)
              Tester:
              Anna Carissa Sadia
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                11/Mar/19

                  Time Tracking

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