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

[Kunal Bajaj]

Hi,

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]

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.  

https://ej2.syncfusion.com/angular/documentation/grid/observables/ 

  

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

https://ej2.syncfusion.com/angular/documentation/grid/observables/#handling-grid-actions 

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.  

https://ej2.syncfusion.com/angular/documentation/grid/paging/ 

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

https://ej2.syncfusion.com/angular/documentation/grid/virtual/ 

Refer to the following demos.  

Observables Async Pipe: https://ej2.syncfusion.com/angular/demos/#/material/grid/async-pipe 

Virtualization: https://ej2.syncfusion.com/angular/demos/#/material/grid/virtualization 

Pager: https://ej2.syncfusion.com/angular/demos/#/material/grid/paging 

Regards,  

Seeni Sakthi Kumar S.