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!

Defer execution of region until selected in region selector

John_KJul 19 2017 — edited Aug 3 2017

I have a page with a number of classic report regions and a region selector. When the page loads, the code for each region is executed and then I can switch between them - all good. However - whilst I might have say 5 regions, a particular user may only want to look at 2 of them on a particular day (there are no specific rules for this to allow me to conditionally hide them), however they have the overhead of waiting for all queries to run before the page is rendered. Ideally what I'd like is the active region to render and then as the user clicks the tabs to switch to the other regions, they render at that point. I'm guessing I could do this with jQuery by using dummy items that cause the SQL to return no rows, then setting them using the region switch callback and PPR'ing the selected region but I think that's going to be massively complex.

Does anyone have any better suggestions before I either write it off as being not worth the effort, or go down a rabbit warren doing something that's actually reasonably easy.

I ideally want to avoid coding up my own region selector.

This post has been answered by John_K on Aug 3 2017
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 31 2017
Added on Jul 19 2017
2 comments
2,541 views