Filter elements in tables

Filter elements in tables

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

  1. In a table, in the model row, in a column showing a property, click on Filter.
  2. In the field Operation, choose how the filter should be applied. See the table below for an explanation of the options.
  3. 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

  1. In a table, in the model row, in a column showing a related element, click on Filter.
  2. 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.
  3. 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.

  1. In the overview, click on Show filter.
  2. In the filter row, click on Add filter.
  3. In the dialog Add filter, in the field Filter on, select an element or inner element from the table to apply the filter to.
  4. 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.
  5. 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:

    • Contains: Filter elements that contain a specific value for a certain property.
    • 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.

Edit and remove a filter applied to a table

  1. 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: .
  2. In the overview, click on  Show filter in case the filter row is not shown.
  3. 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.
Back

Request a demo

Fill in our form and one of our colleagues will contact you as soon as possible to schedule a demo.

Please enable JavaScript in your browser to complete this form.
Please enable JavaScript in your browser to complete this form.

Download the whitepaper

Please enable JavaScript in your browser to complete this form.
Addresss

Get in touch

Fill in our form and one of the Relatics members will contact you as soon as possible. Do you prefer contact by phone? Please call us at +31 180 413 047.
Please enable JavaScript in your browser to complete this form.