Rex Wong asked 9 months ago
I have a table with about 5710 records using select-multiple feature. as you can see the URL is appending all the selected value, and it turned out to be very long and even longer than the limitation.
How can I fix it?
https://ebstoolsdev.secheron.net/index.php?ORG_ID=104&grid_id=listass&_search=true&nd=1708569632545&rows=20&jqgrid_page=1&sidx=1&sord=asc&filters=%7B%22groupOp%22%3A%22AND%22%2C%22rules%22%3A%5B%7B%22field%22%3A%22WS_DESCRIPTION%22%2C%22op%22%3A%22in%22%2C%22data%22%3A%22CS+-+120t+injection%2CCS+-+300%2F500%2F600+injection%2CCS+-+300t+compression%2CCS+-+600%2F1000+compression%2CCS+-+CNC+composite%2CESS+Cabling%2CKappa+Processing%2CMA+-+Brazing+-+Amisa%2CMA+-+Brazing+-+EDM%2CMA+-+Finish+-+Tumbling%2CMA+-+Hand+-+Araldit%2CMA+-+Hand+-+Braids%2CMA+-+Hand+-+Coil%2CMA+-+Hand+-+Deburring%2CMA+-+Hand+-+Komax%2CMA+-+Hand+-+Magnets%2CMA+-+Lathe+-+NL%2CMA+-+Lathe+-+NZ%2CMA+-+Lathe+-+Tornos%2CMA+-+Milling+-+GROB%2CMA+-+Milling+-+NH4000%2CMA+-+Milling+-+NH5000%2CMA+-+Milling+-+SV500%2CMA+-+Subcontracting%2COBE+CMD+FG%2COBE+CPM%2COBE+Corrail+FG%2COBE+Energy+meter+FG+-+REM%2COBE+Energy+meter+FG+-+RTP%2COBE+Energy+meter+SA+-+Access.%2COBE+Energy+meter+SA+-+El.+Ass.%2COBE+Engraving%2COBE+ImpGen+FG%2COBE+ImpGen+SA+-+Access.%2COBE+ImpGen+SA+-+Cables%2COBE+ImpGen+SA+-+El.+Assembly%2COBE+ImpGen+SA+-+Engraving%2COBE+ImpGen+SA+-+Mech.+Assembly%2COBE+ImpGen+SA+-+Opt.+Sensor+Ass.%2COBE+Pixy+FG+-+INC-1xx.xx%2COBE+Pixy+FG+-+INC-9xx.xx%2COBE+Pixy+FG+-+PIXY+1000%2COBE+Pixy+FG+-+SIP-3x.xx%2COBE+Pixy+SA+-+Accessories%2COBE+Pixy+SA+-+El.+Assembly%2COBE+RT+-+Cable+Coils%2COBE+RT+-+Mechanical+Tachymetry%2COBE+Speedo+FG%2COBE+Speedo+SA+-+El.+Assembly%2COBE+Teloc+FG+-+Teloc+1500%2COBE+Teloc+FG+-+Teloc+2500%2COBE+Teloc+FG+-+Teloc+3000%2COBE+Teloc+FG+-+Teloc+4000%2COBE+Teloc+SA+-+Accessories%2COBE+Teloc+SA+-+El.+Assembly%2COBE+Teloc+SA+-+Engraving%2COBE+Teloc+SA+-+Mech.+Assembly%2COBE+Terminal+box+FG%2CSA+-+ModBox+Assembly%2CSA+-+ModBox+Sub+Assembly%2CSA+-+Pantograph+Assembly%2CSA+-+Pantograph+Sub+Assembly%2CSA+-+Sub-assembly+ESS%2CUndefined%2CUndefined+-+WS+Missing%2CWE+-+Welding+Alu%2CWE+-+Welding+Robot%2CWE+-+Welding+Steel%2CWorkstation+L01%2CWorkstation+ZETA%22%7D%2C%7B%22field%22%3A%22URGENCY%22%2C%22op%22%3A%22cn%22%2C%22data%22%3A%221%22%7D%2C%7B%22field%22%3A%22ITEM_CODE%22%2C%22op%22%3A%22cn%22%2C%22data%22%3A%22sg%22%7D%5D%7D
Abu Ghufran Staff answered 9 months ago
Hello,
Thanks for reporting this issue. We use $_GET method for search ajax calls inside grid and querystring has limitation on browser / server side.
Ideally it should have used $_POST here but as I can see now, it will need core level changes and testing. Currently, the search filter you are trying is not doable with this version.
