Author Topic: Issue with filtering the grid data when we have more than 150 filter values  (Read 1090 times)

fuljoyment

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 14
    • View Profile
Hello Admin,

I am facing a problem with filtering the data in the pqGrid. The filter values filled remotely and we are using remote data.  I am using the following filter rule in my grid.

Code: [Select]
{
   title: "colorName", align: "center", dataIndx: "color", width: "120",
       filter: {
           crules: [{ condition: 'range'}]
               }
 },


As per my observations, if we have more than 150 filter values and do filtering by checking/unchecking them then  the data in the grid is not updating. Also, if we uncheck all then checking them one by one then the data is updating.


Note:- I am using Paramquery Version 6.2.4 with ASP.Net Core MVC..


Thanks in advance,

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6307
    • View Profile
Re: Issue with filtering the grid data when we have more than 150 filter values
« Reply #1 on: September 12, 2021, 12:49:45 pm »
this may be due to server configuration not accepting query strings beyond a certain character length.

Please check requestLimits maxQueryString setting in web.config or set dataModel.method to "POST" in grid.