Filtering In ADF Table Not Working in case of Using MYSQL Database (Doc ID 2092310.1)

Last updated on FEBRUARY 03, 2016

Applies to:

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

Symptoms

In case of ADF table with filter enabled, the filtering doesn’t work and actually doesn’t retrieve any data at all. This issue happens while using MYSQL Database.

When logging is enabled for the application, either via the WebLogic diagnostic console or by adding the Java Option "-Djbo.debugoutput=console" to the project properties Run configuration, we can see that when using filtering on the table following WHERE-clause is used:

‘WHERE ( ( (<EntityObjectName>.<VariableName> LIKE ( :<ViewCriteria> || ‘%’) ) ) )‘
For Example: ‘WHERE ( ( (EmployeesEo.FIRST_NAME LIKE ( :vc_temp_1 || ‘%’) ) ) )‘.

 

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