A.3.2.1. Limit the Scope of Comparisons
When comparative operators are used, values can be defined as a range between two numbers,
rather than a one ended range. In other words, if a "Greater Than" operator is used, it can be
matched with a "Less Than" operator in order to limit the scope of the comparison.
Example: Define a clue that counts calls placed after 5:00 pm (17:00). Assume that the clue
is named "AFTER_5", the maximum count is 30, and the variable "A" represents the time the
call was placed. The most direct way to define this clue is as follows:
^B81,AFTER_5\30\A>17:00
However, when the clue is defined this way, headers and summaries with alphabetic characters
in the "A" field will also appear in the count. To prevent the clue from counting "non-data",
the "A" variable can be defined as a range as shown below:
^B81,AFTER_5\30\A>17:00*A<99:99
This definition would prevent the clue from including "non-data" records that have alphabetic
characters in the "A" field, since alphabetic characters would have a value higher than 99:99.
A.3.2.2. Exclude Non-Data Characteristics
Another way to eliminate non-data from the count is to define the clue in a manner that
excludes the characteristics of headers and call accounting summaries.
If you examine the data generated by the PBX, there is usually a factor which differentiates
non-data from call records. In some cases, call records will always begin with a specific
character, and non-data will omit this character. In other cases, non-data will have a specific
text item in a field, where call records will have a numerical value. Once you have determined
a factor that differentiates between non-data and call records, it is relatively simple to define
clues that exclude the non-data.
Example: Define a clue that counts calls lasting three minutes or longer. Assume the clue is
named "LONGCALL", the maximum count is 40, and the variable "B" represents the call
duration. The most direct way to define this clue is as follows:
^B81,LONGCALL\40\B>=03:00
However, when the clue is defined this way, headers and summaries with alphabetic characters
in the "B" field would also appear in the count.
In order to exclude undesired records, assume you have determined that call records always
begin with the character "|" (vertical bar). In order to use this knowledge in the clue definition,
you would first re-define the format to include the variable "L" to represent the first character
in the record, and then re-define the clue as follows:
^B81,LONGCALL\40\B>=03:00*L=|
This definition would exclude headers and summaries by only counting records that begin with
the "|" (vertical bar) character.
Apx-11
PollCat III - Pollable Call Accounting Terminal, User's Guide Appendices