Apply DataGrid sort and filter on export

This guide shows how to apply DataGrid sort and filter when exporting to Excel or CSV.

Quick video

1. Create new CRUD application from our Sample database and open Orders page.

2. Add a Button component above the DataGrid component, choose Export action for Button Click event and ivoke the same data source method used to populate DataGrid data on Page Load event. Provide ${grid0.Query.Filter} and ${grid0.Query.OrderBy} as $filter and $orderby parameters.

3. Run the application, apply sort and filter and press Export button.

We are here for you

Making our users happy is always a priority for us.