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
Schakel JavaScript in je browser in om dit formulier in te vullen.

Download the whitepaper

Schakel JavaScript in je browser in om dit formulier in te vullen.

Download the whitepaper

Request a demo

Fill in the below information and we will contact you to schedule a demo.

Schakel JavaScript in je browser in om dit formulier in te vullen.
We will use this information to contact you.
Schakel JavaScript in je browser in om dit formulier in te vullen.
Schakel JavaScript in je browser in om dit formulier in te vullen.
Addresss

Neem contact op

Vul ons formulier in en een van de Relatics medewerkers neemt zo snel mogelijk contact met u op. Liever telefonisch contact? Bel ons op +31 (0) 180 413 047.
Schakel JavaScript in je browser in om dit formulier in te vullen.