Replies

• tangerine Posts: 3,365Questions: 39Answers: 395

  February 2015

  The screenshot says

  Showing 1 to 10 of 10 entries (filtered from 216 total entries)
  

  so it is correct that pagination only has one page. You need to find out where you are applying a filter or query while retrieving the data.
• allan Posts: 63,689Questions: 1Answers: 10,500 Site admin

  February 2015

  recordsFiltered :10

  It should be 216 in this case unless you have a filter applied as @tangerine says.

  Allan
• ersecchio Posts: 3Questions: 0Answers: 0

  February 2015 edited February 2015

  At load of page the datatables sent via GET to the various parameters, the following
  ....
  length = 10
  order[0][column] 3
  order[0][dir] desc
  search[regex] false
  search[value]
  start = 0
  ...

  then "start" and "length".

  The controller of server inizialize the response variabile in this mode:
  "recordsTotal" = > Select all records from table, without filtering = SELECT * FROM table
  "recordsFiltered" => Select records from table with LIMIT, then "start" and "lenght" = SELECT * FROM table LIMIT 0, 10.
  "data" => array of 10 items

  and then
  recordsTotal: 216
  recordsFiltered :10

  maybe something wrong?
• allan Posts: 63,689Questions: 1Answers: 10,500 Site admin

  February 2015

  Yes - recordsFiltered is not the page length. It would be worth reading over the documentation for those parameters:

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

  Allan
• ersecchio Posts: 3Questions: 0Answers: 0

  February 2015

  RESOLVED.

  The "recordsFiltered" has a value different of "recordsTotal". The "recordsFiltred" is the number of items after globalSearch or columnSearch.

  If there is no search (globalSearch or columnSearch) , then the value "recordsFiltered" is equal to "recordsTotal".

  :)