Total entries differs from # of returned values and # of pages are a fraction of expected.
Total entries differs from # of returned values and # of pages are a fraction of expected.
cgdave
Posts: 3Questions: 1Answers: 0
I am using server side processing and running into an issue displaying all the results. In the info section I have this message "Showing 31 to 31 of 31 entries (filtered from 647 total entries)". However, there are only two pages available in the pagination section. As a result I am only able to view 60 results rather then the full 647.
a portion of the response is shown below.
{"draw":1,"recordsFiltered":31,"recordsTotal":647....}
I'm not sure as to why this would be happening
This discussion has been closed.
Answers
That means you have a search applied to the table. Sounds like you have Page Length of 30. With the search applied you have only 2 pages worth of data you can view.
Kevin
Hmm strange. In the request, I am not passing anything into the search parameter. Search is disabled on my table. Could search still be the cause of this issue given the fact it's not enabled?
Can you post all the parameters sent in the XHR request?
Maybe there is a columns search? Do you have statesave enabled that is causing a search? Can you post a link to your page so we can take a look?
What is the server script you have. If the parameters sent are correct is it parsing the parameters correctly?
Kevin
State save is enabled, however the search being applied to that obj is an empty string.
I am unable to share a link of the page and the server script is parsing the parameters correctly.
Not sure what you are doing with the
request
variable.StateSave will override the config options. You can use
stateSaveParams
to modify what is saved. The docs have an example of resetting the search string.Does the
Search
input have a search term when reloading the page?If this doesn't help the please post the following:
data
object.Or you can use the debugger to collect information for the developers to look at.
Kevin