4 Replies Latest reply on Sep 19, 2018 10:03 AM by klacey

IG only returning 50 rows on first visit to page

Jeremy Webb Sep 13, 2018 2:17 PM

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

1. Re: IG only returning 50 rows on first visit to page

Dharmendra Kumar-Oracle Sep 13, 2018 2:53 PM (in response to Jeremy Webb)

Do you have any query condition to filter our the data?
Like Show 0 Likes(0)

Actions
2. Re: IG only returning 50 rows on first visit to page

Jeremy Webb Sep 14, 2018 8:52 AM (in response to Dharmendra Kumar-Oracle)

Hi,

The SQL is quite long with lots of conditions, but what happens is that first time into the page it only shows 50 records. If I just refresh the page then all 400 are shown. So it would appear to be something in the grid that is saying only return the first 50 rows but it does not realise there is more to come later when you step through to the following pages.

Looking at the apex debug output, it has appended the following to the query,

where ROWNUM <= :p$_max_rows

Where is p$_max_rows defined? Could it be this that is stopping it.

Thanks,

Jeremy
Like Show 0 Likes(0)

Actions
3. Re: IG only returning 50 rows on first visit to page

Jeremy Webb Sep 18, 2018 8:49 AM (in response to Jeremy Webb)

Any ideas on this?
Like Show 0 Likes(0)

Actions
4. Re: IG only returning 50 rows on first visit to page

klacey Sep 19, 2018 10:03 AM (in response to Jeremy Webb)

Info: I work with Jeremy
Seems that Apex has led us a little dance here.
There is a page item in the query for the IG containing a date in DD-MON-YYYY format.

On entry to the page - the page item is empty.

When we run the IG source SQL in the underlying schema - 0 rows are returned.
In the Apex page IG - we are having 50 rows returned - but when paginating past page 5 (10 rows per page) - no rows are returned

We currently have no explanation for the 50 rows being returned but it is consistent.
(yes - have cleared cache for all time and restarted browser and retested this situation)

Defaulting the page item in a pre-header process TO_CHAR(SYSDATE,'DD-MON-YYYY') has resolved the 50 rows issue
1 person found this helpful
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.