Overview
The data in a grid or chart can be automatically sorted by adding a default sort order on the backing view. For more information on sort orders see Sort Order.
The default sort order can be overwritten at any time by a user, by right clicking on a column header and clicking Sort Ascending or Sort Descending.
The data in displayed on the grid can be filtered in the following ways
| Filter | Location | Link | Reason to use |
|---|---|---|---|
| Default Filter | View Editor | Filter | Default filters can be cleared by the user on the front end. Use a default filter when users are allowed to remove the filter to view all the data. If a default filter has been applied grids and charts are marked with Example: A grid displaying a list of employees has an Active Boolean attribute. The default filter only displays active employees, but a user can clear this filter at any time to view all employees. |
| Background Filter | View Editor | Filter | Background filters cannot be cleared by the user. Use a background filter to always filter any instance of the view by the parameters provided. Views can be reused by multiple data components. Using a background filter will filter all components which are backed by this view. |
| Background Filter Rules | Component Editor | Filter Rule | Background filter rules appear on the data component instead of the backing view so only applies to that component. Rules can be added to each filter to only apply in certain contexts. Background filter rules cannot be cleared by the user. Use this option to create multi-layer hierarchical graphs where the data displayed on the chart is dependant on data points selected on another chart. Example: A button is clicked to show all employees for company X. This sets a hidden attribute to true. The background filter only applies when this hidden attribute is marked as true. |
| Column Filter Pickers | Grid Column Headers | Controlled exclusively by the user on the front end. Users can select any attribute on a grid and filter using expressions and by selecting values.
|
More Information
For a complete list of view properties and their functions see View.