Columns filters not showing all available options: search not working

Hi,

I have partially got to the bottom of this: it appears that the grid samples the first 1,000 records to get values for the filters: we have put our own filters to restrict the data set so it does not go over that. However we still have the problem with the search not working - and it would be helpful to get more information server-side on data retrievals triggered by opening a filter list so we can control how the filter list gets its data  (and make it much more efficient).  Simply grabbing all the data every time is a very inefficient way of doing this -we can write server-side code that intelligently supplies the right values.

...  function begin(args) {          if (args.requestType == 'filterbeforeopen') {              cloneQuery = this.query;              this.query = new ej.data.Query().addParams("excelfilter", true);          }      }...

[.cs]  ...  if (dm.excelfilter)              {                  DataSource = operation.PerformTake(DataSource, 2);    //we have just passed the first two records to the excel filter items                  //You can change the filter data according to your requirement here              }  ...

1. “not seem to be working for any of the filter styles” here what do you mean by ‘filter styles’, please explain in detail on this?
2. By default ‘number’ and ‘date’ fields are set with ‘equal’ operator while searching from excel filter, so please provide more details about the fields?
3. Please share your full grid server and client side code example?

Hello everyone, this is my issue right now using the last version. The issue its in the filter of cuorse

// Grid’s actionBegin event function  function onActionBegin(args) {          if (args.requestType === "filterchoicerequest") {‘              // Filter choice count is modified              args.filterChoiceCount = 1500;  //modify value here as you want          }  }

<script>      function begin(args) {         if (args.requestType === "filterchoicerequest") {              var filterfields = [];              var objFilter = Object.keys(args.filterModel.existingPredicate);              for (var i = 0; i < objFilter.length; i++) {                  filterfields.push(objFilter[i]);              }              filterfields.push(args.filterModel.options.field);              args.query.distincts = [];              args.query.select(filterfields); // Created the select query            }        }  </script>

public IActionResult UrlDatasource([FromBody]DataManagerRequest dm)          {              IEnumerable DataSource = order;              DataOperations operation = new DataOperations();  . . . . . . . .               int count = DataSource.Cast<Orders>().Count();              if (dm.Select != null)              {                  DataSource = operation.PerformSelect(DataSource, dm.Select);  // Selected the columns value based on the filter request                   DataSource = DataSource.Cast<dynamic>().Distinct().AsEnumerable(); // Get the distinct values from the selected column               }  . . . . . .               return dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource);          }