The following image shows the configuration for the autocomple type
- Choose your datasource created recently here.
- Select Autocomplete customfield type.
- Put your SQL query .
- Put your column name to display it .
- Type of data to selected (Manual or Automatique).
- 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.