Now you can declaratively create an item that provides an inline list of values that also filters while typing in the item. The list is populated by the list of values defined for the item, this can only be a dynamic list of values. There are several options when creating this item type.
An explanation of some of the options:
- Search: this defines how the search is performed, search for any character (contains) or match the characters exactly. This option also defines if the search is case-sensitive or not.
- Only Values from List: if set to yes, this means that only a value from the list of values is valid.
- Lazy Loading: Yes means the list will be read from the database every time the user types a character. No means the list will only be populated when the page is rendered.
- Maximum Values in List: this limits the number of values in the list.
- Highlight Search: when set to yes, this will highlight the matching characters in the list.
We create an example autocomplete item P6_DEMO_STATE that list all of the states from the table demo_states. The search type is set to Contains & Ignore Case and the search is highlighted. This gives the following result in our page:
The new Text Field with autocomplete really gives something extra to the user interface. Of course you should be cautious on what table you define this item, because it generates a lot of queries, especially with the Lazy Loading set to yes. All in all, another nice new feature in APEX 4.0.[Oracle APEX 4.0] Text Field with autocomplete,