Filter
Top Products
13-70
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13 Managing Reports
Hiding and Filtering Report Data
Setting Filter Values
After you choose a condition, you set a filter value.
Step 1 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.
Table 13-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 characters.
_ 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