Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Amit M 3Amit M 3 

How can I do pagination with large volume data in aura components?

I have requirement to do pagination for around 10000 records. However it is not possible with using OFFSET as it has limitation for 2000 records. I cannot use StandardSetController in AuraEnabled method context either. 

Is there any other possible way that can be tried?
Khan AnasKhan Anas (Salesforce Developers) 
Hi Amit,

Greetings to you!

You can use lazy loading technique that allows you to load data or javascript component asynchronously and increases the performance and data will reflect on the fly. Please refer to the below links which might help you further with the above requirement.

https://newstechnologystuff.com/2018/09/19/lightning-data-table-with-lazy-loading/

https://forcerangers.wordpress.com/2018/06/20/lazyloading/

http://sfdcmonkey.com/2019/03/05/infinity-lazy-loading-salesforce-lightning/

Also, please refer to this link: https://salesforce.stackexchange.com/questions/237905/is-it-possible-to-display-15-000-records-in-lightning-component

I hope it helps you.

Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.

Thanks and Regards,
Khan Anas
Amit M 3Amit M 3
In first link, it seems they are using record ID to paginate through the records. I am not sure if that is reliable way of paginating as ID is var char and if we do greater than on it, it wont behave properly.