Cisco Systems OL-24201-01 manual Setting Filter Values, 13-70

Chapter 13 Managing Reports

Hiding and Filtering Report Data

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		quantity = 10
	of another expression using:		custName = 'Acme Inc.'
	•	Equal to	custName > 'P'
			custState <> 'CA'
	•	Not Equal to	orderDate > {d '2005-06-30'}
	•	Less Than
	• Less Than or Equal to
	•	Greater Than
	• Greater Than or Equal to
Range	Tests whether the value of an expression falls or		price BETWEEN 1000 AND 2000
	does not fall within a range of values using		custName BETWEEN 'E' AND 'K'
	Between or Not Between. The test includes the		orderDate BETWEEN
			{d '2005-01-01'} AND {d '2005-06-30'}
	endpoints of the range.
Membership	Tests whether the value of an expression matches		officeCode IN (101,103,104)
	one value in a set of values using Any Of.		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		custName LIKE 'Smith%'
	does not match a specified pattern using Like or		custName LIKE 'Smiths_n'
	Not Like. % matches zero or more characters.		custState NOT LIKE 'CA%'
	_ matches one character.
Null value	Tests whether a field has or does not have a null, or		manager IS NULL
	missing, value using Is Null or Is Not Null.		shipDate IS NULL
			shipDate IS NOT NULL

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.

	User Guide for Cisco Secure Access Control System 5.3
13-70	OL-24201-01