Autocomplete type

Autocomplete type Configuration steps

1. Choose your datasource created here;
2. Select Autocomplete  customfield type;
3. Insert your SQL query;
4. Insert your column alias;
5. Insert your column name to be displayed ;
6. Choose the loading data type (Manual or Automatique);
7. Select if the search for the entred word should be in all the data returned by the query, or only at the begining;
8. Select if the search is case sensitive or not;
9. Put the number of characters to be entered to start the search;
10. Put the number of results returned by the  the query;
11. You can add dependent fields;
12. Test your configuration and click on done.