beautypg.com

Quick reference to query filter operators – HP Intelligent Management Center Standard Software Platform User Manual

Page 472

background image

Select

Example

Retrieve this data

And

Customers who ordered
supplies in Q1 and in
Q2 (the data you re-
trieve will include: cus-
tomers who placed or-
ders in both Q1 and
Q2).

Data true for both filters.

Or

Customers who ordered
supplies in: Q1 or Q2
(the data you retrieve
will include: customers
who placed orders in
Q1only; customers who
placed orders only in
Q2, and; customers who
placed orders in both
Q1 and Q2).

Data true for any one of
the filters.

Quick reference to query filter operators

The following table will help you select the operator you need to define a
query filter.

Filter created

Select

Example

Values to re-
trieve

Equal
to US

Equal to

Retrieve data for
the US only.

Values equal to a
value you specify.

472

Crystal Reports 2008 SP3 User's Guide

Building Queries

18

Query filters and prompts