To clear all Data Filter Parameters, type ^B42 [Enter].

CAUTION: Data Filter Parameters that have been cleared cannot be recovered. The Data Filter Parameters must be redefined manually, unless the

configuration has been saved as described in Section 8.

6.3.

Enabling the Data Filter

After Parameters are defined, the Data Filter must be enabled. Enter the Command Mode and type ^B56,2 [Enter].

6.4.

Logical and Relational Operators

The following logical and relational operators may be used in the definition of Data Filter Parameters.

Operator Definition

> Greater Than or Equal To < Less Than or Equal To ~ Not Equal To

= Wild Card

, AND

[Enter] OR

6.4.1. "Equal To" Conditions

In addition to the operators listed above, an "equal to" condition can also be created by entering the variable along with the desired field contents as shown below.

Example : Assume the variable "B" represents the field that indicates whether the call is

inward or outward bound (Figure 6.3). Given the Data Filter Format shown in Figure 6.3, to define the Data Filter Parameters to only store records for outward bound calls, type the following:

^B42,BOUT [Enter]

Where ^B42 is the "Define Data Filter Parameters" Command, and BOUT tells PollCat III to monitor the position assigned to variable "B", and save records with the text "OUT" in this field.

PollCat III - Pollable Call Accounting Terminal, User's Guide The Data Filter

|08:15|OUT|040|01:15|8531212 |DDD|00.10| |08:17|OUT|007|00:30|411 |DDD|00.10|

|08:21|IN |005|00:43| | | |

---BBB---AAAAAAA--- Figure 6.3: Example of "Equal To" Condition

6.5.

Logical AND/OR Conditions

Logical AND/OR conditions allow PollCat III to monitor a specific call record field for a range of acceptable values, or monitor several fields simultaneously.

6.5.1. AND Conditions

An AND condition creates a situation where two or more expressions must all be true in order for the record to be stored. AND conditions are created by invoking Command ^B42 in a manner where two or more parameters are included in a single command line as shown below.

^B42,parameter_1,parameter_2,... etc.

Where each parameter is separated by a comma, and includes a variable and the criteria that PollCat III will use to determine whether the call record will be stored or omitted.

Example : Assume variable "A" represents the call time as shown in Figure 6.4. To store only

records for calls received or placed between 8:00 am (08:00) AND 5:00 pm (17:00), type the following:

^B42,A>08:00,A<17:00 [Enter]

Note the following:

·

Each parameter is separated by a comma.

·

The format for time values must exactly match the format found in the PBX call records. If the record shows the time as "08:00", the parameter definition must also specify the time as "08:00". If the time is specified as "8:00" or "0800", the Data Filter will not function.

PollCat III - Pollable Call Accounting Terminal, User's Guide The Data Filter

|08:15|OUT|040|01:15|8531212 |DDD|00.10| |08:17|OUT|007|00:30|411 |DDD|00.10|

|08:21|IN |005|00:43| | | |

-AAAAA--- Figure 6.4: AND Condition Example

6.5.2. OR Conditions

An OR condition creates a situation where, if any of two or more expressions are true, the record will be stored. An OR condition is created by invoking Command ^B42 with each parameter entered on a separate command line as shown below.

^B42,parameter_1 [Enter] ^B42,parameter_2 [Enter]

... etc.

Each parameter includes a variable and criteria that will be used to determine whether the call record will be stored or omitted.

Example : Assume variable "A" represents the field for call time, and variable "B" represents

the extension number. If the Data Filter Format is defined as shown in Figure 6.5, and you want to store call records received or placed before 6:30 pm (18:30), OR calls received or placed at extension 099, define the Data Filter Parameters as follows:

^B42,A<18:30 [Enter] ^B42,B099 [Enter]

Note the following:

·

Each parameter is entered on a separate ^B42 command line.

·

The format for any alphanumeric value must exactly match the format found in the PBX call record.

·

Command ^B42 has a cumulative effect. Each time ^B42 is invoked, its associated parameter is added to the existing Data Filter Parameter definition.

COMMAND: If Command ^B42 is entered without a parameter (e.g. ^B42 [Enter]), all previously defined Data Filter Parameters will be erased.

PollCat III - Pollable Call Accounting Terminal, User's Guide The Data Filter

|08:15|OUT|040|01:15|8531212 |DDD|00.10| |08:17|OUT|007|00:30|411 |DDD|00.10| |08:21|OUT|099|00:43|5555555 | | | -AAAAA---BBB--- Figure 6.5: OR Condition Example

6.6.

Data Filter Parameter Definition Examples

The following examples are based on fictional PBX call record formats. When designing your own Data Filter, be aware that the record format will differ from those shown in the examples. When defining the Data Filter Format and Data Filter Parameters the following factors must be considered.

·

Exact Match : Alphanumeric values in parameters definitions must exactly match those

found in the PBX call record. If the record shows the time as "09:00", then the parameter definition must also list the time as "09:00", and not "0900" or "9:00".

·

Number of Characters : For any given variable, the number of characters specified in the

Data Filter Format must exactly match the number of characters indicated in the Data Filter Parameter definition. For example, if the filter format defines the variable "B" as the first seven characters of the number dialed, then the parameter definition must account for all seven characters.

·

Cumulative Effect : Each time Command ^B42 is invoked, PollCat III will add the new

parameter to the existing definition. Make certain newly defined parameters do not cancel out the effect of existing parameters.

·

Slashes and Backslashes : The slash character (/) cannot be used in the parameter

definition. The slash character is reserved for use as a command separator, when several commands are entered on the same line. If your call record format uses a slash to separate values in the time or date field, the Data Filter Parameter definition must use a backslash character (\) in place of the slash.

In document PollCat III. Pollable Call Accounting Terminal. User's Guide (Page 40-45)