We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Filtering and Sorting to work on entire data at backend having data over 1 million

Thread ID:





146814 Aug 21,2019 09:48 AM UTC Aug 22,2019 07:27 AM UTC Angular - EJ 2 1
Tags: Grid
Kunal Bajaj
Asked On August 21, 2019 09:48 AM UTC


I have implemented a data table and wanted to confirm few things.

I want to bring only 200 at a time, firstly I am having more than 1 million records in my Database that can be manged using pipe.. and is working fine.
But if I use filter or sort now, I want it to query or fetch data from entire database records (1 million records) and not just the records present at that moment

can you please let me know if it is achievable or not?

Seeni Sakthi Kumar Seeni Raj [Syncfusion]
Replied On August 22, 2019 07:27 AM UTC

Hi Kunal, 

Greetings from Syncfusion.  

To bind a remote data to the server using Angular Observables, we are using Async Pipe. This has been discussed in the following Help Document.  

Grid actions like Paging, Sorting were also handled and their query will be executed within the dataStateChange event.  

Enable pager in the Grid for better performance. Use the pager with the Observables concept which will bring the data to the Grid on pagination. Refer to the following Help Document.  

If you wish to use the unpaged scrolling, you can prefer the Virtualization concept of the Grid with the Observables.  

Refer to the following demos.  

Seeni Sakthi Kumar S. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon