ADF Table Filter With Input Words "OR" Or "AND" Not Working

(Doc ID 2350366.1)

Last updated on JANUARY 18, 2018

Applies to:

Oracle JDeveloper - Version and later
Information in this document applies to any platform.


On : version, ADF UI (Faces, ADF Mobile, Swing, Desktop Integration)

af:table filtering does not work when searching words beginning by "AND" or "OR"

An ADF application has a page with an af:table with filtering enabled.

It is possible to filter a table's field by entering the first letters of one of the values in the field.
The value entered in the filter is case-insensitive.
For instance, if the value in the field is "California" the in the filter you can enter "cal" and upon filtering that record will be listed between the matching records.

When the table has a field with a value beginning by "AND" or "OR" the corresponding records are not returned.

The records beginning by "AND" or "OR' are expected to be returned.




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms