Cannot edit more than 200 rows at the same time

Cannot edit more than 200 rows at the same time

si08789si08789 Posts: 15Questions: 6Answers: 0

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

  • allanallan Posts: 63,498Questions: 1Answers: 10,471 Site admin

    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 the form-options object to be changed (i.e. submit the changed parameters only) - if that works it would suggest it is a hard limit in the HTTP server.

    Regards,
    Allan

This discussion has been closed.