My Oracle Support Banner

ADF Table Filter With Input Words "OR" Or "AND" Not Working (Doc ID 2350366.1)

Last updated on APRIL 12, 2024

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 with "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", then 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 with "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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.