Apply filter to grid on page load

[Bermuda]

Hello,

I have an Ajax Kendo grid and would like to apply a filter on load.  There is a date column that I would like to get the max date and use that as the initial filter (not hardcoding the value).  Is this doable and if so how?

Thanks

D

[Mihaela]

Hello,

Since you have submitted the same query as a support ticket, and I have already answered your question in the support thread, I will post the same here in case someone else has the same question:

The easiest approach will be to get the latest date on the server, store it in ViewData in the Action method that returns the View with the Grid, and pass it in the Filter configuration. For example:

• Action method that returns the Grid View:

public IActionResult Index()
{
  //access the Grid data from the sort the data to get the latest date
  ViewData["maxDate"] = new DateTime(2022, 1, 15); //store the date in ViewData
  return View();
}

• Pass the ViewData in the Filters configuration of the DataSource:

.DataSource(dataSource => dataSource
                .Ajax()
                ...
                .Filter(filters =>
                {
                    filters.Add(product => product.OrderDate).IsGreaterThanOrEqualTo(ViewData["maxDate"] as DateTime?);
                })
)

 

Regards, Mihaela Progress Telerik