Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Faceted Search Report pagination on REST Data Source does not work after filter/selected facet

ilmarskOct 13 2021

Hello,
Apex 20.2.0.00.20; Listener 19.4.6.r1421859; Oracle 18c XE
Running Faceted Search report on top of REST data source (simple http) . Rest does not have any pagination and always returns all records. Search Result region (classic report) attributes for Number of Rows = 50, Pagination Type = Row Range X to Y (with next and previous links), partial page refresh checked.
There are no default filter setting on the initial report load. The report returns all 50 rows (i.e. out of 350) and pagination works just fine. However, as soon the value of a facet is selected (filter applied) the report returns & displays the first 50 filtered rows, but when trying to paginate rows 51+ nothing is returned (i.e. filtered population 74 rows).
Have tried to: a) pass the facet filters to REST Data source - rest now returns 74 rows, but pagination still does not work past 50; b) various pagination settings + no partial page refresh; c) looked for optimizer hint to revert pagination back to pre 18.1 version with APEX$USE_ROWNUM_PAGINATION and APEX$USE_NO_PAGINATION hints.
Does anybody have run into the same problem? Any suggestions on how to make pagination work for filtered faceted search report from REST data source? Built in pagination is preferred, but wondering if local post processing is an option for a workaround. NOTE: Rest will always return a full set of data and does not support pagination.
Thank you.

This post has been answered by Carsten Czarski-Oracle on Oct 13 2021
Jump to Answer

Comments

Post Details

Added on Oct 13 2021
8 comments
66 views