You can create a query in two ways. You can use the Query editor and Display
editor to specify the filter criteria and fields to display, or you can use
the Query wizard.
To create a query by using the Query wizard:
Click Query and select Use Query Wizard.
Click Query > New Query.
In the Choose Record Type window, select Defect and
click OK.
You can use an existing query as a template in the Query wizard. This
exercise does not use a template, so click Next.
Use the Define how the query displays page to choose
the fields from the Defect record type to display in the query results. To
choose a field from the Fields pane, double-click it
or drag it to the Display Format grid. Choose the following
fields to display:
Headline
Owner
Priority
State
Use the Sort Order column to specify the order
in which to display the query results. Enter numbers in the Sort
Order cells as follows:
Priority 1
State 2
Owner 3
Headline 4
Use the Sort column to specify an ascending or
descending sort order. Click the Sort cell for each
display field once to set the ascending sort order. Click Next.
Use the Select fields to use as query filters page
to specify which fields to use as filters in establishing the query's selection
criteria. Double-click the State field. Click Next.
Specify the filters and selection criteria:
Select Define Filter.
Select Contains from the Operator list,
and select the Not check box.
Click Values. In the Select Values window,
select Closed and Resolved and
click OK. The query is now defined to return all records
that are not in a closed or resolved state.
Click Run to run the query.
Examine the records that the query returns in the Results grid.
Click File > Save as. Enter NotClosedorResolved in the Query
Name field, and click OK to save the query
in the Personal Queries folder of your workspace.