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

Database activity field based on SQL code

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: Future Dev
    • Fix Version/s: None
    • Labels:

      Description

      Hi Everyone,

      I would like to propose a database field based upon a SQL query entry box containing some constants such as USERID.

      For example,

      A field with a window where you can type in a select statement.

      SELECT c.fullname FROM mdl_courses AS c JOIN mdl_enrol ... JOIN mdl_user_enrolments AS ue... WHERE ue.userid = USERID 

      In this case, the field will load up all user courses.

      Such a field would be very flexible and useful.

      Obviously, due to the type of data you could obtain, the plugin would need to be restricted by user privileges.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              acheckley Andrew C
              Participants:
              Component watchers:
              Adrian Greeve, Mihail Geshoski, Peter Dias
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: