Working in Datasources View Mode for Data Transfer to Select Box Element

1. Open the Datasources module.

2. Create a table containing your data. Example: Department table.

3. Add the required columns to the table (e.g. DepartmentName).

4. Create a new SQL Action from the Actions section. Example: SelectDepartment.

5. Write the following query in the SQL Editor:

SELECT * FROM Department

     6. Save the Action.

‍