Apply DataGrid sort and filter on export (Angular)

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 Page properties filter and sort equal to ${event.filter} and ${event.orderby}in DataGrid LoadData event.

3. Add a Button component above the DataGrid component, choose Export action for Button Click event and ivoke the same data source method used in DataGrid LoadData event using filter and sort Page properties as $filter and $orderby parameters.

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