This is a Course custom field Plugin that basically provides a way to add a dynamic select/multi-select custom field to store information related to the course which takes input as SQL query and makes the select field based on the output of SQL query.

Installation

Intall this plugin directly from UI. Site Administration => Plugin => install plugin 

OR copy the folder to your-moodle/customfield/field/

Use

    1) Add Dynamic Dropdown Menu field in Course customField
    2) In the SQL query field, enter the SQL statement with two select field id and data
        For Eg: select id, data from table_name
    3) Check the "Enable auto-complete mode" option if required.
    4) Check the "Enable Multi-select" option if required.
    5) For Multi-select, the default value can have multiple values in comma-separated format
	otherwise enter a single value.
    6) Now add / edit a course and select the option from dropdown menu