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, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: