Cannot edit more than 200 rows at the same time
Cannot edit more than 200 rows at the same time
Hi Alan,
I have a complex (at least from my point of view...) table with more than 300 rows. When I select all of them (with the button), all are selected and then if I edit one field it edits just the first 200 rows, and reloads the table with just these 200 rows.
Any ideas why this exact number? Is it some kind of datatables limit?
The only way to finish the edition is to select the other rows helped with the shift.
I have an ajax in a postedit which works well and I don't think it has anything to do with this. I cannot let you in the table because it has sensitive data.
I would appreciate any kind of help.
Answers
DataTables doesn't have any hard limits in it, but it is possible that the HTTP server might be truncating the data. Have you taken a look at the server's error log? Some servers have a limit on the number of parameters that can be sent.
It might also be worth setting the
submit
option of theform-options
object to bechanged
(i.e. submit the changed parameters only) - if that works it would suggest it is a hard limit in the HTTP server.Regards,
Allan