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.