Defining queries: example

Define a query for resolved CRs for products named hammer, saw or drill.

Procedure

  1. In the Report Builder dialog box, click Define Query.
  2. Select the query criteria:
    1. Find all resolved CRs for the hammer, saw, and drill products.
    2. 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')

  3. Click Update.

Feedback