Pagination server side still used datatable limit offset
Pagination server side still used datatable limit offset
reiki
Posts: 46Questions: 11Answers: 0
hey i have my own filter to LIMIT and OFFSET for the query but datatable still add that into the last query making it theres 2 LIMIT and OFFSET is there a way to disable that ?
This question has an accepted answers - jump to answer
Answers
If you have server-side processing enabled, then yes, Editor's server-side libraries will always add those properties. You would need to edit the code in the library to disable that if you wanted to add it yourself (although, wouldn't you just be adding the same values? Otherwise that would mess up the client-side paging controls).
What server-side libraries are you using - PHP, .NET or Node.js?
Allan
Iam using php for this
This is the line to comment out if you wanted to specify your own offset / limit.
I'm still not clear on how this would interact with DataTables paging though?
Allan
Just realised from your other thread that you aren't using our PHP libraries but rather yajra's. You'd need to contact them to find out how to do it in their libraries as they are not written or supported by me.
Allan
okay thanks alot allan