Default filter value for DataGrid column

This guide demonstrates how to set default filter value for DataGrid column.

Source Code

Step by step

1. Create new application with .NET server-side project and add new MSSQL data-source connected to Northwind database.

2. Create new Orders page and bind DataGrid to Orders table.

3. Add new Page property defaultOrderID, define $filter parameter for Northwind.getOrders method invoke on Page load event, define $filter parameter ${event.filter ? event.filter + ' and ':''}OrderID eq ${defaultOrderID} for Northwind.getOrders method invoke on DataGrid LoadData and bind DataGrid OrderID column to defaultOrderID.

4. Set defaultOrderID to this.grid0.columns.first.filterValue in DataGrid LoadData event and define $filter parameter ${event.filter ? event.filter + ' and ':''}${this.defaultOrderID ? 'OrderID eq ' + this.defaultOrderID : ''} for Northwind.getOrders method invoke on DataGrid LoadData.

5. Run the application

Get Radzen