I-Activity Monitor - Data Table Filter Tool


Filter Tool

The Data table filter tool (shown below), located just below the table header, provides an additional level of filtering that is performed locally.

The filter tool allows you to select specific data for any column of data listed in the table. Any filter that does not contain the specified data is removed from view.


Using the Filter Tool

To use the filter tool, perform the following steps:

Step 1

From the first (left-most) drop-down list field, select a column header - for example, Mgr Agent Name - from the list of currently displayed columns (see Customizing Layout of the Data Table for information on displaying columns).

Step 2

From the second drop-down list field, select a filter matching types.

Step 3

In the field on the right, enter any data to be displayed in the selected column. Any item in the Data table that does not contain this filter data in that column is removed from view — immediately and automatically.
 

Note

Data entered in this field is case-sensitive.

Step 4

To re-display the original list of matches, delete the data in the field on the right.

Filter Matching Types

The following table identifies the available filter matching types.
 

Filter Type

Description

==

Displays entries whose data in the selected column is equal to the filter data.

!=

Displays entries whose data in the selected column is not equal to the filter data.

>

Displays entries whose data in the selected column is greater than the filter data.

>=

Displays entries whose data in the selected column is greater than or equal to the filter data.

<

Displays entries whose data in the selected column is less than the filter data.

<=

Displays entries whose data in the selected column is less than or equal to the filter data.

Date Offset

Note

This filter matching type is available only when the column being filtered contains date information.

 
Displays entries whose data in the selected column meets the user-supplied date offset. Date offsets can be back or forward in time in time some number of days, hours, minutes, or seconds.
 
The syntax for the date offset specification is: {-|+}n{d|h|m|s}
 
"-" indicates an offset in the past. Matches will be made for filtered column values that have a date value greater than "now-offset". The value of "now" is recalculated for each filter operation. Therefore, the filtered contents of the table will always match the user specified offset. In other words, as time changes, items in the table that once matched may no longer match and be removed from the table.

  • "n" is a user specified number.
  • "d" (or "D") is used to indicate that the "n" should be calculated as days.
  • "h" (or "H") is used to indicate that the "n" should be calculated as hours.
  • "m" (or "M") is used to indicate that the "n" should be calculated as minutes.
  • "s" (or "S") is used to indicate that the "n" should be calculated as seconds.

For example, a user supplied value of "-5h" will match table items who's filter column date value is 5 hours or less in the past.
 
If the user enters invalid syntax, the background color of the filter text box will turn red and an unfiltered table will be displayed. When the syntax is corrected, the background will return to it's normal color (white).

Contains

Displays entries whose data in the selected column contains the filter data. For example, if the filter data is system, entries containing both test system and demo system in the selected column would display. Similarly, if the filter data is 0, entries containing both 0 and 100 in the selected column would display.

Wild Cards

Displays entries whose data in the selected column is equal to the filter data, taking into account the special characteristics of wild card characters.
 
Valid wild card characters are * and ? .

  • * (asterisk) will match any character any number of times. So, a filter value of * will match everything. A filter of T*e will match Te, Three, and This is one of three.
  • ? (question mark) will match any character one time. So, a filter of JOB ? TEST will match JOB A TEST, JOB B TEST, and JOB C TEST.

If a literal interpretation of the wild card characters is required, the characters must be escaped. Wild card characters are escaped by prefixing them with the backslash character ( \ ). So, a filter value of This is ok\? would match This is ok? but would NOT match This is ok. .

REGEX

This matching type is for power users. It allows the user to specify a regular expression for the filter value. Regular expressions allow you to create very complex matching criteria. For documentation on the specifics of the regular expression engine used in I-Activity Monitor, refer to the Java documentation at

http://java.sun.com/j2se/1.5.0/docs/api/java/util/regex/Pattern.html .

 
If the user enters invalid syntax for the regular expression, the background color of the filter text box will turn red and table will continue to use the last valid filter. When the syntax is corrected, the background will return to it's normal color (white).

BLANK

Displays entries whose selected column is blank. Selecting this filter type will disable and grey out the filter text box (since no user input is required).

NA

Displays entries whose selected column greyed-out NA used to designate fields that have not yet been seeded with a value (value is "Not Available"). Note that the grayed-out NA indicates a lack of value and is different from a blank field and different from a field that actually has a real value of NA.