Issue While Performing Search Operation With af:Query and Results Displayed in af:Table With Pagination (Doc ID 2067083.1)

Last updated on OCTOBER 21, 2015

Applies to:

Oracle JDeveloper - Version 11.1.1.7.0 to 12.1.3.0.0 [Release Oracle11g to 12c]
Information in this document applies to any platform.

Symptoms

Implementing af:query with the search results displayed in af:table which is paginated. The observation is that, when user changes the search criteria, new results are NOT displayed in table from Page1. New results are displayed from the page number, opened during previous results.

Example:
1. Perform search and results are displayed in ADF table in 3 pages - 1,2,3
2. User clicks on page number 2.
3. User performs the new search and results are displayed in table. But the current page displayed is page 2.

Expected Behavior: New results should always displayed from page 1. i.e,when user performs the new search, the results should be displayed from the page 1 and the page should redirect to the page 1 ( irrespective of where the user was, in the previous search.)

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