2011

Combining Drawing Query Conditions
You can combine query conditions when creating a query to retrieve drawing
objects.
Example: Combine a property condition with a location condition to find all
utility poles within 100 meters of a road.
When you combine conditions, use Or to specify the union of the conditions,
use And to specify the intersection of the condition, use Not to exclude specific
objects from the query.
■ And — Finds objects only if both conditions are true. For example,
Property: LAYER = First Floor
AND Property: COLOR = BLUE
finds only blue objects on the First Floor layer.
■ Or — Finds objects if either condition is true. For example,
Property: LAYER = First Floor
OR Property: COLOR = BLUE
finds all objects on the First Floor layer (of any color) and all blue objects
on any layer.
■ And Not — Finds objects only if the first condition is true and the second
condition is false. For example,
Property: LAYER = First Floor
AND NOT Property: COLOR = BLUE
finds objects on the First Floor layer that are any color except blue.
■ Or Not — Finds objects if the first condition is true or the second condition
is false. For example,
Property: LAYER = First Floor
OR NOT Property: COLOR = BLUE
finds all objects on the First Floor layer (of any color) and all objects on
other layers that are not blue.
You can use Not by itself to retrieve all except a specific set of objects. For
example, the query definition, Not Property: Layer = Furniture retrieves all
objects except those on the Furniture layer.
If you use more than two or three conditions, it is a good idea to group the
conditions. Conditions inside the group are evaluated first.
Finding and Querying Drawing Objects | 1255