view counter

Input List Of Values, autosuggest behavior

Thanks to Michael Koniotakis for this story

By default when you type a value in an input list of values the query is executed always with the LIKE operator.

Oracle Virtualization and Cloud Consulting
view counter

This is very annoying for users that do heads-down data entry.
Also if the field is a number executed query force full table scan causing performance issues.

We just need the option to disable auto-suggest behavior (on design time) so that the query is executed with '=' operator and the LOV does not open when the value entered is valid.

You can find the details in

Read the entire article at its source

view counter