Last updated on FEBRUARY 03, 2016
Applies to:Oracle JDeveloper - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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 || ‘%’) ) ) )‘.
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