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 12.2.1.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1.1.0 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.

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

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

Changes

 

Cause

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