Dynamic Dropdown menu

This plugin is Course custom field Plugin and provides a new dynamic select/multi-select type custom field that takes input as SQL query and makes the select field based on the output of SQL query.
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