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.
