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

Save course creator id in course table

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Won't Do
    • Icon: Minor Minor
    • None
    • 2.2.1
    • Course
    • Any
    • MOODLE_22_STABLE
    • Hide

      1. Create a course and check the usercreated and usermodified field has the logged in user's id.
      2. Modify the course and check the usermodified field has the logged in user's id.

      Show
      1. Create a course and check the usercreated and usermodified field has the logged in user's id. 2. Modify the course and check the usermodified field has the logged in user's id.

      Here is the use case:
      In our organisation, we have a requirement to generate reports based on the course creators.

      Currently we use the log table to retrieve the course creator. But, since we have implemented log rotation in Moodle and we are missing essential information while generating reports. Our log table is getting bigger in size and has more than 200000 records. It's also a performance issue since we are querying this table only to get the course creator id.

      So it would be nice to have the id of the user who created the course in the Course table.

      Additionally, it may also be nice to have the id of the user who modified the course(last modified by).

            moodle.com Moodle HQ
            gnuwings Sasikala P A
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

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