Search

The JSON response looks like this:

You need to send back the recordTotals and recordsFiltered parameters, as noted in the docs I linked to before. They tell DataTables how many records there are in the data set, and this it can work o…

How we can update the parameter in data tables,

Note no leading zero. (select button '2').

@nosnetrom

What does joinnested.php look like? Does it look something a bit like this?

Your above code is not using server side processing however the response does provide the server side response. You are using jQuery ajax() to fetch the data. If you want server side processing the…

Now I've tried to use the option ajax, as a function that do the same stuff, but I don't know exactly how to give back the data to the dataTables

Use recordsTotal and recordsFiltered rather than iTotalRecords and iTotalDisplayRecords. See the documentation here.

The fact that you are using CakePHP makes little to no difference to DataTables. As long as you respond with the JSON structure that DataTables expects, then it will work on any platform.

"recordsFiltered": 10,

You will need to calculate the total in your server side script and add the total to the JSON response for each draw. The standard response parameters are documented here. For example add something…

Take a look at the expected return data for server side processing. Datatables is expecting recordsTotal and recordsFiltered with lower case r. You have RecordsTotal and RecordsFiltered. Correct t…

I don't know if Yajra works with SearchPanes and server-side processing. I don't recall having seen that before, but I might have just missed it. It seems likely that is the issue though.

Your code is confusing to me. Lets start by getting some basic information first. Most of your code is using Datatables 1.9 syntax but you also have some Datatables 1.10 API calls. I will assume y…

Guessing your recordsFiltered value is incorrect. Is it 10? If it is likely that is incorrect. See the Server Side Processing Returned Data docs for details of what should be returned. If you sti…

You have server side. processing enabled but it doesn't sound like your server scrip tis following the Server Side Processing protocol. Datatables expects certain Returned data to know how much data…

Just make sure your server script returns the expected response data so datatables knows the number of records, etc.

That suggests to me that all.php isn't returning the data that DataTables expects.

When you enable server side processing the server scrip tis responsible for performing the sort, searching and paging functions. None of these will work client side. The client side will send reque…