Holiday Notice: Support will be provided on a limited scale from December 24th, 2024, to January 2nd, 2025. Happy holidays and a wonderful New Year!


Topic: Datatable Async Example with filters and pagination

Ralf priority asked 1 year ago


Hi,

I have two question2 regarding the Async Data Example for Datatables.

Here are our questions.

  1. We have about 1.000.000 datasets and the example has no info about pagination. How can we paginate the data? We don't want to load all datasets and render them in HTML to get them filtered by JS afterwards.

  2. How can we add filters? For example we have a Job Id column and a Employer Id column and want to sent this filter values as well to the async request. How can we archieve that?

We wonder if the Docs are missing this or the async support for datatables is missing these features.

Thanks and best regards,

Ralf


Grzegorz Bujański staff answered 1 year ago


Datatable was not designed to handle very large datasets. All operations take place on the client side. The async data example is intended to show how you can fetch data asynchronously. This solution does not support full server-side support

You could handle data filtering yourself at the moment - it is enough for search input to query the API for the appropriate data and replace it in the Datatable. It will be more difficult to handle pagination. You would have to hide the default pagination, create your own, and ensure that it loads new data into the Datatable when the page changes.

We are currently working on a product that will provide the ability to handle large amounts of data, including server-side sorting, server-side data filtering, server-side pagination and many other solutions that are not supported in Datatable.


Ralf priority commented 1 year ago

Hi Grzegorz,

thanks for your reply. We finally managed to add all filters to the Ajax Request. We will give it a try to build our own pagination.

Looking forward for your new product.

Thanks and best regards,

Ralf



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: Priority
  • Premium support: Yes
  • Technology: MDB Standard
  • MDB Version: MDB5 6.3.1
  • Device: HP Laptop
  • Browser: Firefox 113.0.2
  • OS: Ubuntu
  • Provided sample code: No
  • Provided link: Yes