Menu
I'm reading datatable doc's but i can't find an answer. My question is:
I have a table with 10.000 rows. I do a search by state and result is 3000 rows. From 3000 rows, i'll show 20 per page.
"recordsTotal": what value should be in here?, "recordsFiltered": what value should be in here?,
If recordsTotal value must be 10.000, can i hide this value if is not interesting?
522
jQuery DataTable is a powerful and smart HTML table enhancing plugin provided by jQuery JavaScript library. It is a highly flexible tool that is basically created to display information in tables as well as adding interactions to them, hence, enhancing data accessibility in HTML tables.
The draw event is fired whenever the table is redrawn on the page, at the same point as drawCallback (technically the callback fires before the event, but they occur sequentially and thus either can be used to achieve the same effect).
bDestroy. Show details. Replace a DataTable which matches the given selector and replace it with one which has the properties of the new initialisation object passed. If no table matches the selector, then the new DataTable will be constructed as per normal.
From official documentation:
recordsTotalTotal records, before filtering (i.e. the total number of records in the database)
recordsFilteredTotal records, after filtering (i.e. the total number of records after filtering has been applied - not just the number of records being returned for this page of data).
Your response should be:
{ "draw": 1, "recordsTotal": 10000, "recordsFiltered": 3000, "data": [ // ... skipped 20 records ... ] } I believe recordsTotal is only used for informational panel Showing 1 to 20 of 3000 entries (filtered from 10000 total entries). If you're not using informational panel, you don't have to return recordsTotal property.
Property recordsFiltered is also used by jQuery DataTables to calculate number of pages required to display your dataset.
See Server-side - Returned data for more information.
150
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
