Datatables server-side sorting and pagination


Topic: Datatables server-side sorting and pagination

Torroni pro asked 2 years ago

Expected behavior I think it would be extremely useful to enhance the Datatables component in such a way to enable server-side sorting and pagination. Client-side sorting is only useful when the dataset is small. If the table is populated with the results of a query performed on a database, the result set could contain millions of records. Possible implementation: add an event that is fired when the use clicks on a sort arrow and another event that is fired when the user clicks on a pagination button; add the necessary logic to allow the client javascript code to update the data after such events are fired but before the table is re-rendered.

Actual behavior Datatables performs client-side sorting and pagination. To implement server-side sorting and pagination, one has to use the simple table and add all the necessary UI components and event handlers, which is a lot of work.

Resources (screenshots, code snippets etc.)


kpienkowska staff answered 2 years ago

We are working on developing tables that will support server side sorting and pagination and will generally be optimized to handle large amounts of data.


Torroni pro commented 2 years ago

Great, this is good news.


MikeOnline pro premium priority commented 2 years ago

Any change we can get OData Support?


kpienkowska staff commented 2 years ago

I'm sorry but I can't give you an answer to that question at the moment. I will get back to you when I get an answer from the team responsible for this project.


desarrollo.ossc pro premium priority commented a year ago

Hello there, Still no pagination or server-side sorting?


Grzegorz Bujański staff commented a year ago

Unfortunately not. We are still working on creating tables that support server-side sorting, filtering, and pagination


kissn0rbert pro premium priority commented 9 months ago

Hey hey, is there any update about it?


Grzegorz Bujański staff commented 9 months ago

We are working on the release. I cannot say exactly when the new product will be available, but as soon as everything is ready, we will inform about it on our social media and this information will appear on our website.


blazej.norys@fiserv.com commented 7 months ago

Hi guys, any news about this sorting and pagination features? When can we expect a release?


Kamila Pieńkowska staff commented 7 months ago

Here is page dedicated to the new product: https://getdataden.com


blazej.norys@fiserv.com commented 7 months ago

Does the MDBBoostrap Pro include DataDen or does it have to be purchased separately?


Kamila Pieńkowska staff commented 7 months ago

It is separate product.


ChenQingze pro premium priority commented 4 months ago

Any news about server-side sorting and pagination features recently ?


Kamila Pieńkowska staff commented 4 months ago

We have developed a new product designed specifically for advanced table features: https://getdataden.com


Please insert min. 20 characters.

FREE CONSULTATION

Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.

Status

Answered

Specification of the issue
  • User: Pro
  • Premium support: No
  • Technology: MDB Standard
  • MDB Version: -
  • Device:
  • Browser:
  • OS:
  • Provided sample code: No
  • Provided link: No
Tags