13-71
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 Managing Reports
Hiding and Filtering Report Data
Setting Filter Values
After you choose a condition, you set a filter value.
Step1 To view all the values for the selected column, select Select Values.
Additional fields appear in the Filter dialog box as shown in Figure 13-46. These fields allow you to find
and select a filter value.
Table13-15 Examples of Filter Conditions
Type of filter
condition Description Examples of instructions to data source
Comparison Compares the value of one expression to the value
of another expression using:
•Equal to
•Not Equal to
•Less Than
•Less Than or Equal to
•Greater Than
•Greater Than or Equal to
quantity = 10
custName = 'Acme Inc.'
custName > 'P'
custState <> 'CA'
orderDate > {d '2005-06-30'}
Range Tests whether the value of an expression falls or
does not fall within a range of values using
Between or Not Between. The test includes the
endpoints of the range.
price BETWEEN 1000 AND 2000
custName BETWEEN 'E' AND 'K'
orderDate BETWEEN
{d '2005-01-01'} AND {d '2005-06-30'}
Membership Tests whether the value of an expression matches
one value in a set of values using Any Of.
officeCode IN (101,103,104)
itemType IN ('sofa', 'loveseat', 'endtable',
'clubchair')
orderDate IN
({d '2005-10-10'}, {d '2005-10-17'})
Pattern-matching Tests whether the value of a string field matches or
does not match a specified pattern using Like or
Not Like. % matches zero or more character s.
_ matches one character.
custName LIKE 'Smith%'
custName LIKE 'Smiths_n'
custState NOT LIKE 'CA%'
Null value Tests whether a field has or does not have a null, or
missing, value using Is Null or Is Not Null.
manager IS NULL
shipDate IS NULL
shipDate IS NOT NULL