The Advanced Filter allows you to construct a formula that can restrict the display of data in the Attribute Table and the Map Window based on conditions and logical operators.
- other than
- IS NOT NULL
- IS NULL
- less than
- less than or equal to
- equal to
- greater than
- greater than or equal to
- contains phrase
- contains phrase (case-sensitive)
The filter takes into account dictionary values, i.e. wherever a dictionary is assigned to an attribute, dictionary values will appear in the value selection field.
The following query means: Show water pipes (layer) whose pipe function (attribute) contains the phrase “Connection” (attribute value) AND (AND) its design length (attribute) is less than 100 [m] (attribute value).
Other example queries:
Show me luminaires where the light source is LED and their wattage is 30 or 40 W.