Several parameters in URL may kill browser

jstuardo

Hello...

I am having the following issue.

My grid contains several columns. When I refresh the grid (when initializing, searching or sorting), the URL generated is this:

/conductor/get_all?draw=4&columns[0][data]=&columns[0][name]=&columns[0][searchable]=true&columns[0][orderable]=false&columns[0][search][value]=&columns[0][search][regex]=false&columns[1][data]=id&columns[1][name]=&columns[1][searchable]=true&columns[1][orderable]=true&columns[1][search][value]=&columns[1][search][regex]=false&columns[2][data]=nombres&columns[2][name]=&columns[2][searchable]=true&columns[2][orderable]=true&columns[2][search][value]=&columns[2][search][regex]=false&columns[3][data]=apellidos&columns[3][name]=&columns[3][searchable]=true&columns[3][orderable]=true&columns[3][search][value]=&columns[3][search][regex]=false&columns[4][data]=runFormateado&columns[4][name]=&columns[4][searchable]=true&columns[4][orderable]=true&columns[4][search][value]=&columns[4][search][regex]=false&columns[5][data]=empresa&columns[5][name]=&columns[5][searchable]=true&columns[5][orderable]=false&columns[5][search][value]=&columns[5][search][regex]=false&columns[6][data]=licencias&columns[6][name]=&columns[6][searchable]=true&columns[6][orderable]=false&columns[6][search][value]=&columns[6][search][regex]=false&columns[7][data]=faenas&columns[7][name]=&columns[7][searchable]=true&columns[7][orderable]=false&columns[7][search][value]=&columns[7][search][regex]=false&columns[8][data]=requisitosWebcontrol&columns[8][name]=&columns[8][searchable]=true&columns[8][orderable]=true&columns[8][search][value]=&columns[8][search][regex]=false&columns[9][data]=infracciones&columns[9][name]=&columns[9][searchable]=true&columns[9][orderable]=false&columns[9][search][value]=&columns[9][search][regex]=false&columns[10][data]=createdAt&columns[10][name]=&columns[10][searchable]=true&columns[10][orderable]=true&columns[10][search][value]=&columns[10][search][regex]=false&columns[11][data]=updatedAt&columns[11][name]=&columns[11][searchable]=true&columns[11][orderable]=true&columns[11][search][value]=&columns[11][search][regex]=false&columns[12][data]=&columns[12][name]=&columns[12][searchable]=true&columns[12][orderable]=false&columns[12][search][value]=&columns[12][search][regex]=false&order[0][column]=2&order[0][dir]=asc&start=0&length=10&search[value]=&search[regex]=false&_=1537540799196

You will see that URL string, without counting the server name, has 2,189 characrers. This is so big, so sometimes I got a 404 error. I am sure this problem is because of this. All other grids I have, with less columns, don't have this problem.

Is there a way to solve this in order to send less characters in query string? for example, I think regex parametes is not necessary and if a column is not orderable nor searchable, maybe the parameter could not be included as part of the query string.

What do you think about this?

Regards
Jaime

kthorngren

If your server script will support or can be configured to support it change from an HTTP GET request to HTTP POST is the best option. Here is an example:
https://datatables.net/examples/server_side/post.html

Kevin

jstuardo

Thanks.. it worked!