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
-
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 ?