Autosuggestions
Under construction
See Also
Advanced Canvas Control Attributes, Data Attributes, Data Mapping, Field Attributes, SQL SELECT, Working with the Lianja Object Model
Overview
Autosuggestions provide filtered choices as the user types in a Form or Canvas Section field.
The choices are displayed in a dropdown under the control. Clicking on a choice loads its value into the field.
Autosuggestions can be:
- Static list with or without a dropdown (autocomplete)
- Dynamic table-based list
- SQL Select based list
- User defined function based list
Autosuggestions are defined by the following field attributes (Data sub-section):
| Attribute | Description |
|---|---|
| Autosuggestions | The list of Autosuggestions values to display as the user types |
| Autosuggestion headers | A comma separated list of column headers to display for the Autosuggestions |
| Autosuggestion column to search | The column to search for Autosuggestions |
Static Lists
Static lists are based on a comma-separated list of choices specified in the Autosuggestions attribute.
Autosuggestions: Buchanan,Callahan,Davolio,Dodsworth,Fuller,King,Leverling,Peacock,Suyama
With a standard static list, the dropdown is displayed as the user types, showing filtered values based on the input.
Typing 'd' displays all the values from the list starting with 'd' or 'D'.
Prefixing the list with '-' does not display the dropdown. Instead, it operates as an autocomplete.
Autosuggestions: -Buchanan,Callahan,Davolio,Dodsworth,Fuller,King,Leverling,Peacock,Suyama
Typing 'd' autocompletes with the first value in the list starting with 'd' or 'D'.
Dynamic List
A dynamic list is based on the evaluation of an expression from a specified table.
@<table-name>,<expression>
Here the list is based on the current values of the lastname field from the employees table.
Autosuggestions: @employees,lastname
The dropdown displays filtered values from the table.
SQL Select Lists
SQL Select lists are generated by the resultset from a SQL Select statement.
Here the list is based on the current values of the lastname field from the employees table.
Autosuggestions: select lastname from employees
The dropdown displays filtered values from the resultset.
The SQL Select statement can reference more than one column.
Autosuggestions: select lastname, firstname from employees
By default, the first column is the search column.
Clicking on a choice will load the value of the search column into the field.
For multi-column SQL Select lists, the Autosuggestion headers attribute can be used to specify a comma separated list of column headers for the dropdown.
Autosuggestions: select lastname, firstname from employees
Autosuggestion headers: Surname,Firstname
The dropdown is displayed with column headers.
For multi-column SQL Select lists, the Autosuggestion column to search attribute can be used to specify the column to search.
Columns are numbered from 0. Here the lastname column is the search column.
Autosuggestions: select firstname, lastname from employees
Autosuggestion headers: Firstname,Surname
Autosuggestion column to search: 1
The second column is the search column.
Clicking on a choice will load the value of the search column into the field.
