How to use limit with serverside: true?

keker

How to get first 200 rows using LIMIT in Datatables Editor PHP? If i use serverSide: true, $q0>limit(200); doesnt work (like in this https://datatables.net/forums/discussion/32113/or-where-sql-limit)...

kthorngren

With server side processing the expected number of rows returned is expected to be the value in the length parameter or less rows. The length parameter is based on the page length. Do you have a page length of 200?

This is described here:
https://datatables.net/manual/server-side

Maybe something like the pipelining feature is what you are looking for:
https://datatables.net/examples/server_side/pipeline.html

Kevin

keker

Length parameter doesnt work too

allan

Perhaps you can link to a page showing the issue so we can take a look and try to offer some help.

Allan