Is there a way to make the type ahead function in autocomplete return text that matches anywhere in a field name?
In one of our DBs, every single field name is prefixed by the table name. So if the table is EMPLOYEE, the fields in that table are EMPLOYEE_ID, EMPLOYEE_FIRST, EMPLOYEE_LAST, etc. As a result, iwhen using the autocomplete type ahead feature to put a field into a query, it's tedious to have to type "EMPLOYEE_" every time before getting to the part that matters.
Is there a way to make the type ahead feature look matching text anywhere in the column name? For example, typing "FIRST" would pull up "EMPLOYEE_FIRST"?