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

Update course timemodified on bulk category move

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 3.7.5, 3.8.2
    • 3.8
    • Course
    • MOODLE_38_STABLE
    • MOODLE_37_STABLE, MOODLE_38_STABLE
    • MDL-67638_master
    • Hide

      Requirements

      1. Access to Moodle database.

       

      Testing scenario

      1. Login as admin.
      2. Go to Site administration > Courses > Manage courses and categories.
      3. Create a couple of courses into the "Miscellaneous" category.
      4. Execute the following SQL and take note of their 'timemodified' value: 

        SELECT id, category, fullname, timecreated, timemodified FROM mdl_course ORDER BY id DESC

      1. Check the 'timemodified' is exactly the same as the 'timecreated'.
      2. Go to Site administration > Courses > Manage courses and categories.
      3. Create a course category.
      4. In the 'Miscellaneous' box on the right, mark as selected the courses you've checked in the database.
      5. Select a different category in 'Move selected courses to...' dropdown, and click Move.
      6. Go to Site administration > Reports > Live logs.
      7. Check a new 'Course updated' event has been created for each moved course.
      8. Execute the following SQL:

        SELECT id, category, fullname, timecreated, timemodified FROM mdl_course ORDER BY id DESC

      1. Check in the database 'timemodified' field for those courses has changed.
      Show
      Requirements Access to Moodle database.   Testing scenario Login as admin. Go to Site administration > Courses > Manage courses and categories. Create a couple of courses into the "Miscellaneous" category. Execute the following SQL and take note of their 'timemodified' value:  SELECT id, category, fullname, timecreated, timemodified FROM mdl_course ORDER BY id DESC Check the 'timemodified' is exactly the same as the 'timecreated'. Go to Site administration > Courses > Manage courses and categories. Create a course category. In the 'Miscellaneous' box on the right, mark as selected the courses you've checked in the database. Select a different category in 'Move selected courses to...' dropdown, and click Move. Go to Site administration > Reports > Live logs. Check a new 'Course updated' event has been created for each moved course. Execute the following SQL: SELECT id, category, fullname, timecreated, timemodified FROM mdl_course ORDER BY id DESC Check in the database 'timemodified' field for those courses has changed.

      When a course is moved from one category to another on the category list screen, its timemodified date should be updated to the current time.

            tiennguyenphuc Tien Nguyen
            tiennguyenphuc Tien Nguyen
            Amaia Anabitarte Amaia Anabitarte
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            Janelle Barcega Janelle Barcega
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

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

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