HP Intelligent Management Center Standard Software Platform - Manual (Page 475)

Filter created Select Example
Values to re-
trieve
Matches
pattern, '72'
Matches pattern
Retrieve cus-
tomers whose
date of birth is
1972.
Values that in-
cludes a specific
string.
Different
from pattern, '72' Different from
pattern
Retrieve cus-
tomers whose
date of birth is not
1972.
Values that don't
include a specific
string.
Both "fixed" and
"mobile"
Both
Retrieve Telco
customers who
have both a fixed
telephone and a
mobile phone.
Values that corre-
spond to two val-
ues you specify.
"fixed" Except
"mobile"
Except
Retrieve Telco
customers who
have a fixed tele-
phone, but don't
have a mobile
phone. Values that corre-
spond to a single
value and do not
correspond to an-
other value you
specify.
Editing and removing query filters
You can edit and remove filters on queries.
To edit a query filter
1. Double-click the filter you want to edit.
Crystal Reports 2008 SP3 User's Guide 475
18 Building Queries
Query filters and prompts