Through the chart below we can define all the options that will be part of the Form application Filter.
Image1: Search Settings Interface.
- EmptySearch - Display all records (for empty fields).
- Search Criteria - Select the SQL "AND" or"OR" commands to define the search criteria.
- Display Condition - Display search condition to user selection.
- Using Auto-complete in the Fields - Field turns autocomplete automatically according to the existing values in the database, if the user chooses "Yes", the autocomplete will be enabled automatically for all fields that possess database relationship. If the option is set as "No" no
autocomplete will displayed. If the selected option is "Defined in the field" it will be respecting the individual configuration of each field.