CODEWITHSUNDEEP
jquerydatatables
Marcelo Agimóvel
Marcelo Agimóvel

Reputation: 1719

recordsTotal, recordsFiltered explanation Jquery DataTable

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?

Upvotes: 27

Views: 33220

Answers (1)

Gyrocode.com
Gyrocode.com

Reputation: 58890

From official documentation:

recordsTotal

Total records, before filtering (i.e. the total number of records in the database)

recordsFiltered

Total 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.

Upvotes: 36

Related Questions