Applying Filters to DataGrid
You can use different filters to display in DataGrid only required information.
Note: filters settings can be applied only for SharePoint lists. It is impossible to filter information from SQL server.
If you try to define filter for SQL data source, you will see the notification as follows:
Click “Modify Shared Web Part” and move to “Filters Settings” block.
To define the conditions for displayed items click . Now use special operators and values to define the filter.
Click “OK” to finish adjustment or click “Apply” to save the settings and continue.
Now if an item satisfies defined filter, it will be displayed in the DataGrid.