Autocomplete type

Autocomplete type is a feature that allows Kepler - SQL Query Fields | Grids & Dashboards custom field to automatically complete the remain of a word given by the user.

Autocomplete type Configuration steps

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