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!

IG only returning 50 rows on first visit to page

Jeremy WebbSep 13 2018 — edited Sep 19 2018

Apex 5.1.4

I have an IG which shows about 400 rows.

It is set so that pagination is page mode.

It is set to display 10 rows per page

When I first go into the page it shows the first 10 rows, if I click through the pages, when I click to go to page 6 it then shows no data found.

If I refresh the page all is fine.

Is it like it has retrieved the first 50 rows but does not then retrieve any more. Note this is only on the first entry to the page.

As far as I can tell IG does not have anywhere that limits the number of rows returned, and it can't be this as subsequent visits to the page show all records.

Any ideas?

Thanks,

Jeremy

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 17 2018
Added on Sep 13 2018
4 comments
1,680 views