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

Add a filter to "browse list of users" for date of user account creation

    XMLWordPrintable

    Details

    • Affected Branches:
      MOODLE_310_STABLE, MOODLE_400_STABLE
    • Fixed Branches:
      MOODLE_400_STABLE
    • Pull Master Branch:
    • Testing Instructions:
      Hide

      Manual test

      1. Login as admin
      2. Create a new user with username "user"
      3. Edit the admin and new user account timecreated field to known values, e.g. MySQL:

        UPDATE moodle.m_user SET timecreated = 1609506000 WHERE username = 'admin'; # January 1st 2021 13:00
        UPDATE moodle.m_user SET timecreated = 1627819200 WHERE username = 'user';  # August 1st 2021 13:00
        

      4. Navigate to Users > Accounts > User management in site administration
      5. Add Time created to Default user filters and save changes
      6. Navigate to Users > Accounts > Browse list of users in Site administration
      7. Set Time created is after 1 July 2021 and press Add filter
      8. Confirm only test user is listed
      9. Remove all filters
      10. Set Time created is before 1 July 2021 and press Add filter
      11. Confirm only admin user is listed
      Show
      Manual test Login as admin Create a new user with username "user" Edit the admin and new user account timecreated field to known values, e.g. MySQL: UPDATE moodle.m_user SET timecreated = 1609506000 WHERE username = 'admin'; # January 1st 2021 13:00 UPDATE moodle.m_user SET timecreated = 1627819200 WHERE username = 'user'; # August 1st 2021 13:00 Navigate to Users > Accounts > User management in site administration Add Time created to Default user filters and save changes Navigate to Users > Accounts > Browse list of users in Site administration Set Time created is after 1 July 2021 and press Add filter Confirm only test user is listed Remove all filters Set Time created is before 1 July 2021 and press Add filter Confirm only admin user is listed

      Description

      We have clients who create user accounts for their users by automated process ahead of the users logging in. These clients would like to delete user accounts who have never logged in, but only accounts greater than a certain age.

      Moodle's database stores the date of user account creation, but it is not easy to access this information through Moodle's front end.

      It would be good if the "browse list of users" screen had a date filter for "account creation", similar to the existing filters for "first access", "last access" and "last modified" so our clients  could combine that with the "never accessed" tickbox to give a list of users who've never accessed the system and who have accounts greater than a certain age.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              pholden Paul Holden
              Reporter:
              johnhutchinson John Hutchinson
              Peer reviewer:
              Simey Lameze Simey Lameze
              Integrator:
              Andrew Lyons Andrew Lyons
              Tester:
              Gladys Basiana Gladys Basiana
              Participants:
              Component watchers:
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona)
              Votes:
              9 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 4 hours
                  4h