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!

Interactive Grid - Scroll Pagination - First 40 records only

User_ETDRWMar 24 2020 — edited Apr 29 2020

Hi,

First post on here for me. I am using APEX 19.2. Attempting to convert an old Forms app to APEX.


Please someone tell me I am doing something wrong here but, if I create an IG with scroll pagination, based on a table with say 500 rows in it, the initial query and scrolling fetching more rows seems to work as expected.

If however I refresh by either an automatic timer - or by simply clicking the "Go" button to refresh all the data - I intermittently only get 40 rows - nothing more.

If I do a complete page refresh e.g hit F5 on my browser – it works again i.e. will keep fetching my rows as I page down – but once I do a "Go" manual refresh on the page, it happens again. In reality I will be needing a timer refresh e.g. once every 30 seconds.

I can't believe no-one else has hit this.

The only similar post I have seen was on Stackoverflow from 9 months ago - and the accepted answer was

"This is a known issue; happens when the Pagination type property (found in IG's Attributes) is set to Scroll. Set it to "Page", see if it helps."

... but I don't want Page pagination - I want it to scroll ....

Is this just not working in 19.2 ?

Many thanks

Paul

This post has been answered by User_ETDRW on Mar 26 2020
Jump to Answer
Comments
Post Details
Added on Mar 24 2020
8 comments
2,304 views