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).
- The number of characters to enter to start the search.
- The number of results to return during the execution of the query.
- Test your configuration and click on done.