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

    • MOODLE_310_STABLE, MOODLE_400_STABLE
    • MOODLE_400_STABLE
    • 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

          has been marked as being related by

          Improvement - An enhancement to an existing Moodle feature. MDL-61229 User created date show on profile page?

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

          Activity

            People

              pholden Paul Holden
              johnhutchinson John Hutchinson
              Simey Lameze Simey Lameze
              Andrew Lyons Andrew Lyons
              Gladys Basiana Gladys Basiana
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              9 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                19/Apr/22

                Time Tracking

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