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

    • 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

      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.

        1. MDL-71347_Test Passed.PNG
          48 kB
          Gladys Basiana
        2. MDL-71347 admin.png
          31 kB
          Simey Lameze
        3. MDL-71347 user.png
          70 kB
          Simey Lameze

            pholden Paul Holden
            johnhutchinson John Hutchinson
            Simey Lameze Simey Lameze
            Andrew Lyons Andrew Lyons
            Gladys Basiana Gladys Basiana
            Votes:
            9 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved:

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

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