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.