Define a query for resolved CRs for products named hammer,
saw or drill.
Procedure
- In the Report Builder dialog box,
click Define Query.
- Select the query criteria:
- Find all resolved CRs for the hammer, saw, and drill
products.
- Select an operand, operator, and value, and the appropriate
buttons. Repeat these steps until you complete your query. You can
also type the entire query, or parts of the query, into the Query
String box. Your query string is:
(cvtype='problem')
and
((product_name='drill')
or (product_name='hammer') or (product_name='saw'))
and
(crstatus='resolved')
- Click Update.