Working with relations in filters
You can define filter conditions for indirect attributes using 1:n relations. So network objects can be filtered for compliance with one or all relations. Thus, in each filter condition, select a relation, an attribute of the network object at the other end of the relation, a set operation and an operator.
For example, you can filter all lines which do not traverse a certain link, or all zones connected to a node.
1. Make sure that the filter window of the desired network object type is open (Opening a filter window).
2. Select the desired tab (hierarchical filters) or the desired category in the list (POI filter and GIS object filter), if required.
By default, a row is displayed for the definition of a filter condition.
3. If required, select the Complement option in the column in which you define filter conditions.
Note: If it has been selected, exactly those network objects will be active which would usually be passive and vice versa. If you use the Complement option together with a 1:n relation, please note that Complement refers to the entire condition including the set operation. Applied to a 1:n relation, this means that an All x =Value A condition becomes the One x ≠ Value A condition. |
4. Click the (<Network object type>) button under the Relation column header.
The Relations (<Network object type>) window opens.
5. Open the desired relation.
6. Confirm with OK.
The desired relation is displayed.
Tip: By default, the first entry (<Network object type>) of the selection list is displayed, which does not correspond to any relation. |
7. Click the empty button under the Attribute column header.
The Attributes (<Network object type>) window opens.
Note: In the window not the attributes of the current network object are displayed but all attributes for the destination of the selected relation. |
8. Select the desired attribute.
9. Confirm with OK.
The selected attribute is displayed.
10. In the drop-down list, select the desired set operation from the Set operation column.
Element |
Description |
One |
The operation is performed for the selected object. |
All |
The operation is performed for all objects. |
Note: The field is empty if no 1:n relation has been selected in the Relation column. |
11. For each row, select the desired operator in the Operation column.
Element |
Description |
Is contained in |
is contained in |
Between (limits included) |
greater/equal to value 1 and smaller/equal to value 2 |
< Value |
smaller than value |
< Attribute |
smaller than attribute |
> Value |
greater than value |
> Attribute |
greater than attribute |
≤ Value |
smaller/equal to value |
≤ Attribute |
smaller/equal to attribute |
≥ Value |
greater/equal to value |
≥ Attribute |
greater/equal to attribute |
= Value |
equal to value |
= Attribute |
equal to attribute |
≠ Value |
unequal to value |
≠ Attribute |
unequal to attribute |
Is empty |
there is no entry |
Contains all |
contains all (e.g. transport systems) |
Contains none |
contains none (e.g. transport systems) |
Contains at least one |
contains at least one (e.g. transport system) |
12. Specify the desired value range.
Note: Depending on the selected attribute different input options are provided. |
13. Confirm with OK.
The filter is applied.
Example 1
Find all lines not using link A
- Network object is Line
- Relation is Line routes\line route items
- Attribute is InLink\name
- Set operation is All
- Operator is ≠ value
- Value is A
Example 2
Find all zones connected to node 4711
- Network object isZone
- Relation is Origin connectors
- Attribute is Node\number
- Set operation is One
- Operator is = value
- Value is 4711
If you want to find all zones which are only connected to node 4711, you have to select the All set operator.
Video: How To Use Complex Filters