2011

Table Of Contents
Use the Query Builder
Boolean operators and parenthetical grouping are used to create queries with
two or more search criteria.
The Query Builder tab is the primary query environment. Unlike the Quick
Query and Range Query tabs, the Query Builder can be used to create queries
based on multiple criteria. You can also parenthetically group criteria and
specify what fields are displayed and how they are sorted when the query is
returned in the Data View window.
The Query Builder tab introduces Boolean operators and parenthetical grouping,
which are used to create compound queries based on two or more search
criteria. For example, using Boolean operators, you can generate a query that
returns a list of all light fixtures of a given type that were installed after a
specific date.
And Operator. Constructs a query based on multiple criteria, returning a
set of records that meet all specified criteria. For example, search for all
rooms that are offices and are currently unoccupied. The query returns
records for all rooms that are both offices and unoccupied.
Or Operator. Constructs a query based on multiple criteria, returning a set
of records that meet any of the specified criteria. For example, search for
all rooms that are offices or are currently unoccupied. The query returns
records for all rooms that are either offices or unoccupied.
Parenthetical Grouping. Groups a series of search criteria by bracketing
them within parentheses. For example, search for
(All rooms that are offices and are currently unoccupied)
or
(All rooms that are cubicles and are currently unoccupied)
This query returns a list of all unoccupied offices and cubicles.
You can nest up to four sets of parentheses within a statement.
Use the Query Builder | 1903