If you want to see only a subset of the elements in a table, you can apply a filter to an element based on a property or related element. Once a filter has been applied, the filtered value is displayed as a filter chip at the top of the table in the filter row. This lets you see at a glance if and what filters have been applied to the table. As a result of the applied filter, the number of shown elements relative to the total number of elements is presented in the model row of the table, for example: (6/33).
Add filter to a table from the model row for a property
- In a table, in the model row, in a column showing a property, click on Filter.
- In the field Operation, choose how the filter should be applied. See the table below for an explanation of the options.
- In the dialog Add filter, click on Add.
Operation | Explanation |
---|---|
Contains | Filter elements that contain a specific value for a certain property. For example, filter Requirements that contain ‘height’ in the property Name. |
Is empty | Filter elements that contain no value for a certain property. |
Is not empty | Filter elements that contain a value for a certain property. |
Add filter to a table from the model row for a related element
- In a table, in the model row, in a column showing a related element, click on Filter.
- In the dialog Add filter, in the field Filter by, select the filter’s scope. See the table below for an explanation of the options.
- In the dialog Add filter, click on Add.
Filter by | Explanation |
---|---|
By specific | Filter elements that are related to a specific element. For example, filter Requirements that are related to the Person ‘John Doe’. Choose one or more related elements to apply the filter to. |
Not exists | Filter elements that explicitly have no relation to an element. For example, filter Requirements without a responsible Person. |
Exists | Filter elements that have a relation to an element. For example, filter Requirements with a responsible Person. |
Add advanced filter using the filter row
Applying a filter from the filter row, you have more options available compared to applying a filter from the model row. For example, from the model row, you can only apply a filter on a property or related element that is actually displayed in the table. From the filter row, you can also apply a filter to a property or related element not displayed in the table. In that respect, filtering from the model row is a shortcut to filtering from the filter row.
- In the overview, click on Show filter.
- In the filter row, click on Add filter.
- In the dialog Add filter, in the field Filter on, select an element or inner element from the table to apply the filter to.
- In the dialog Add filter, in the field Filter by, select the filter’s scope. See the table below for an explanation of the options.
- In the dialog Add filter, click on Add.
Filter by | Explanation |
---|---|
By specific | Filter elements on a specific related element. For example, filter Requirements that are related to the Person ‘John Doe’. Choose one or more related elements to apply the filter to. |
Not exists | Filter elements that explicitly have no relation to an element. For example, filter Requirements without a responsible Person. |
Exists | Filter elements that have a relation to an element. For example, filter Requirements with a responsible Person. |
Property of | Filter elements that contain a specific value for a certain property. For example, filter Requirements that have a property with the value ‘Actual’. In the field Property, choose the property to apply the filter to. In the field Operation, choose how the filter should be applied:
|
Edit and remove a filter applied to a table
- In the overview, check if one or more filters have been added by looking at Show filter. In case a filter has been added, the number of applied filters is indicated: .
- In the overview, click on Show filter in case the filter row is not shown.
- In the filter row, in a chip showing the applied filter, click on Edit to edit the filter or click on Delete to remove the filter.