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

Save course creator id in course table

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.2.1
    • Fix Version/s: DEV backlog
    • Component/s: Course
    • Labels:
    • Database:
      Any
    • Testing Instructions:
      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.
    • Affected Branches:
      MOODLE_22_STABLE

      Description

      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).

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: