|
Logical operators (AND, OR, XOR and NOT) can be combined with filter properties to refine the filter query. The default logical operator is AND. All the filtered properties at root level will be considered to have the AND logical operator applied.
The logical operators available are the following:
|
AND:
OR:
XOR:
NOT:
|
All conditions must be true.
At least one condition must be true.
Only one condition must be true.
The condition must be equal to the opposite condition.
|
In the following example all entities that have an area greater than 500.0 square units AND are in the layer LOT will be filtered from the main entity selection set:
.png)
.png)
How to add logical operators:
In the following example, a filtered query will be defined using logical operators. The entities filtered from the main selection set will NOT be in the layer 'HOUSE' AND will have a color equal to red OR have an area greater than 500.0 square units:
1. Right click on the 'Filter properties' node.
2. Select 'Add logical operator > NOT' from the context menu.
.png)
3. Right click on the 'NOT' node and Select 'Add entity from drawing' from the context menu.
.png)
4. Select an entity in the drawing. The entity must have the area property, such as a closed polyline or a circle.
5. Select the LAYER property from the Entity Properties Explorer list. Double-click on the property row or press the 'Select property' button.
.png)
6. Right click on the 'Filter properties' node and select 'Add logical operator > OR'
.png)
7. Right click on the 'OR' node and select 'Add entity from explorer'. The Entities Properties Explorer will be shown with the properties from the last selected entity.
.png)
8. Select the color property from the Entity Properties Explorer list. Double-click on the property row or press the 'Select property' button.
.png)
9. Select the color red from the filter value list and set the relational operator to equal (=)
.png)
10. Right click on the 'OR' node and select 'Add entity from explorer'. The Entities Properties Explorer will be shown with the properties from the last selected entity.
.png)
11. Select the area property from the Entity Properties Explorer by double-clicking on the property row or pressing the 'Select property' button.
.png)
12. Set the relational operator to > (greater than) and the filter value to 500.
.png)
The resulting filter property nodes and logical operators will be like the following:
.png)
Resulting filter query: The entities filtered from the main selection set will NOT be in the layer 'HOUSE' AND will have a color equal to red OR have an area greater than 500.0 square units.
|