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

All How To videos for PTV Visum