Skip to Main Content

Java Development Tools

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ADF Table contentDelivery=immediate

user2555199Aug 12 2014 — edited Aug 12 2014

Hi all again,

I'm using Jdev 12.1.3.

One of my tables has as little as 17 rows. In my page, the AdfRichTable that i'm using to display the content of this table is in a little corner, so I cannot show all the content but just a little part of it. I've decided to make it scrollable with a pageRange of 5.

My problem is: when scrolling down this table, it always displays the fetching data message, even if the whole table only contains 17 rows! I would like my application to fetch the 17 rows at once but only display 5, without displaying any fetching data message when scrolling down.

That's what i've tried (unsuccesfully), separeted and all it once:

- Manually setting the attribute fetchSize to 20, leaving of course the pageRange to 5 --> the scroll bar dissappears and it shows again the 17 rows at once (this I really thing is a bug to be fixed on future Jdeveloper releases)

- Setting contentDelivery to immediate --> Nothing, still appears the fetching data when scrolling down. I can even see, when pushing on "detach" how the 17 rows show up in groups of 5 the first time!

-Check some or all of the following on the tunning section of my view object: Retrieve from database --> all rows, in Batches of -->20  radio button --> All at once

All this did nothing. Either i always get the data in batches of 5 (the amount i set in the pageRange) or i display my 17 rows without scroll bar. It seems I cannot get the crazy thing of getting all the rows I want and showing only few at the time.

For information, this table is the 3rd one in a cascading group of tables, and I've also tried pagination but when detaching the table it keeps the pagination and it's ugly, I want to see the full content of the table (it's only 17 rows, not such a big deal) when pushing on detach button.

Thank you for your help, as I don't know what else to try.

This post has been answered by Ashish Awasthi on Aug 12 2014
Jump to Answer

Comments

Ashish Awasthi
Answer

Hi User

use default setting in ViewObject tuning part

on page select your af:table and set it's auto height rows property to 5 , so it will display a scroll-bar after 5 rows, and then set contentDelivery of table to immediate

don't use page ranging , just use default scrollable access mode

Thanks

Marked as Answer by user2555199 · Sep 27 2020
user2555199

Thank you so much, this has finally worked!

I wonder why in all the blogs I have check about this question before asking here they never mentioned about autoHeightRows.

I really appreciate your help.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 9 2014
Added on Aug 12 2014
2 comments
927 views