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

Allow report columns to define the fields they should be sorted by

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 4.0
    • 4.0
    • Report builder
    • MOODLE_400_STABLE
    • MOODLE_400_STABLE
    • Hide
      1. Log in as admin
      2. Navigate to Users > Accounts > Upload users in site administration
      3. Upload 73112-Users.csv to create lots of users
      4. Navigate to Reports > Report builder > Custom reports in site administration
      5. Create a new report from the Users report source
        • Ensure Include default setup is unchecked
      6. In the report editor, add the User > Full name with picture column
      7. Expand Sorting options
      8. Enable sorting for Full name with picture
      9. Confirm all users are sorted alphabetically (firstname + lastname) ascending
      10. Toggle Full name with picture sorting to descending
      11. Confirm all users are sorted alphabetically (firstname + lastname) descending
      Show
      Log in as admin Navigate to Users > Accounts > Upload users in site administration Upload 73112-Users.csv to create lots of users Navigate to Reports > Report builder > Custom reports in site administration Create a new report from the Users report source Ensure Include default setup is unchecked In the report editor, add the User > Full name with picture column Expand Sorting options Enable sorting for Full name with picture Confirm all users are sorted alphabetically (firstname + lastname) ascending Toggle Full name with picture sorting to descending Confirm all users are sorted alphabetically (firstname + lastname) descending

      Currently Report builder columns are sorted by the first field that they select

      Probably 99% of the time this is fine as they only select a single field, but for those columns that select multiple fields and/or have complex callbacks they need better control to determine how they should be sorted

      One example is the user fullname* columns, that currently sort by the first field (typically {user}.firstname)

            pholden Paul Holden
            pholden Paul Holden
            David Carrillo David Carrillo
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Gladys Basiana Gladys Basiana
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 5 hours, 10 minutes
                5h 10m

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