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.