HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Filtering data retrieval using query filters96
How you combine query filters
You combine filters to retrieve data that corresponds to multiple business criteria. For
example, to retrieve data for customers who live in California and who don’t have a
premium service contract, you combine the following two filters:
Filter 1: [State] Equal to California
And
Filter 2: [Service Contract] Not equal to Premium
Combining query filters
To combine query filters:
1. Create each filter.
For step-by-step information on how to create query filters, see ”Creating a custom
query filter using the Filter Editor” on page 93.
2. Make sure that the Show/Hide Filters pane button on the Query toolbar is pressed in.
You view the filters on the query in the Query Filters pane.
By default Web Intelligence combines the filters with the And operator:
3. You can leave the And operator or change the operator to Or.
This table explains the difference between the And and the Or operators:
You want to retrieve... for example... select...
data true for both
filters,
customers who ordered supplies in
Q1 and who are based in the US
(the data you retrieve will include:
US customers who placed orders
in Q1),
And
data true for any one
of the filters,
customers who ordered supplies
in: Q1 or who are based in the US
(the data you retrieve will include:
worldwide customers who placed
orders in Q1 and US customers
who placed orders during any
quarter),
Or