The following image shows the configuration Select type
- Choose your datasource created recently here.
- Choose Select customfield type.
- Put your SQL query .
- Put your column name to display it .
- Type of data to selected (Single or Multiple).
- You can add dependent field.
- Configuration for dependent fields.
- Test your configuration and click on done.