Chapter 13 Managing Reports

Hiding and Filtering Report Data

Table 13-14

Conditions to Use with Filters (continued)

 

 

 

Condition

 

Description

 

 

 

Bottom N

 

Returns the lowest n values in the column.

 

 

 

Bottom Percent

 

Returns the lowest n percent of values in the column.

 

 

 

Equal to

 

Returns values that are equal to a specified value.

 

 

 

Greater Than

 

Returns values that are greater than a specified value.

 

 

Greater Than or Equal to

Returns values that are greater than or equal to a specified value.

 

 

 

Is False

 

In a column that evaluates to True or False, returns data rows that contain

 

 

false values.

 

 

 

Is Not Null

 

Returns data rows that contain values.

 

 

 

Is Null

 

Returns data rows that do not contain values.

 

 

 

Is True

 

In a column that evaluates to True or False, returns data rows that contain

 

 

true values.

 

 

 

Less Than

 

Returns values that are less than another value.

 

 

Less Than or Equal to

Returns values that are less than or equal to another value.

 

 

 

Like

 

Returns strings that match all or part of the specified string. % matches zero

 

 

or more characters. _ matches one character.

 

 

 

Not Between

 

Returns values that are not between two specified values. When you select

 

 

Not Between, a second Value field appears for the second default value.

 

 

 

Not Equal to

 

Returns values that are not equal to another value.

 

 

 

Not Like

 

Returns strings that do not match all or part of the specified string. %

 

 

matches zero or more characters. _ matches one character.

 

 

 

Top N

 

Returns the top n values in the column.

 

 

 

Top Percent

 

Returns the top n percent of values in the column.

 

 

 

Types of Filter Conditions

Table 13-15describes the types of filter conditions and provides examples of how filter conditions are translated into instructions to the data source.

 

 

User Guide for Cisco Secure Access Control System 5.3

 

 

 

 

 

 

OL-24201-01

 

 

13-69

 

 

 

 

 

Page 433
Image 433
Cisco Systems OL-24201-01 manual Types of Filter Conditions, 13-69