Topic: Datatables server-side sorting and pagination

Torroni pro asked 1 year 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.)


Kamila Pieńkowska staff answered 1 year 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 1 year ago

Great, this is good news.


MikeOnline priority commented 11 months ago

Any change we can get OData Support?


Kamila Pieńkowska staff commented 11 months 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 priority commented 7 months ago

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


Grzegorz Bujański staff commented 7 months ago

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


kissn0rbert priority commented 2 months ago

Hey hey, is there any update about it?


Grzegorz Bujański staff commented 2 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 free commented 9 hours ago

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



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

  • ForumUser: Pro
  • Premium support: No
  • Technology: MDB Standard
  • MDB Version: -
  • Device: -
  • Browser: -
  • OS: -
  • Provided sample code: No
  • Provided link: No