Skip to Main Content

Visual Builder

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.

Required to support huge volume of data in JET oj-table using pagination

User786938-OracleDec 16 2024 — edited Dec 18 2024

We have created a JET page that is invoked from apex. This JET page has table based on row expander and it has to load huge volume of data. If we load all records at one time then this page crashes. So we need to build pagination in this oj-table to fetch small volume of data on demand. I would like to know

  1. If we use loadMoreOnScroll , is it possible to fetch new set of data from data table

      Current Java script that creates data provider has logic         
    
         this.arrayTreeDataProvider = new ArrayTreeDataProvider(this.observableArrayTree, {  
             keyAttributes: 'variablename', childrenAttribute: 'children'  
         });  
    
         // This handles displaying of first node of the tree in expanded form  
        this.dataProvider = new FlattenedTreeDataProviderView(this.arrayTreeDataProvider, {  
             expanded: new ojkeyset\_1.KeySetImpl(\[this.rootvariable\])  
         });
    
    HTML : 
    
                  \<oj-table  
         id="table"  
         aria-label="Redwood Table"  
         accessibility.row-header="name"  
         data="\[\[dataProvider\]\]"  
         layout="contents"  
         columns="\[\[columns\]\]"  
         class="oj-sm-width-full"  
         horizontal-grid-visible="auto"  
         scroll-policy="auto"  
         scroll-policy-options.scroller="#bomitemdef"  
         scroll-policy-options.max-count="1500000"  
         scrollPolicy="loadMoreOnScroll"  
         style="margin-left:0px"                  
         columns-default.resizable="enabled">
    

Any pointer on how to add logic to fetch only certain size of data when scrollbar reaches to end.

or can we use oj-paging-control to support this requirement ?

Comments

Artan Hajdari Feb 11 2025

Can someone help me in this case please

1 - 1

Post Details

Added on Dec 16 2024
0 comments
200 views