Page 6-57
Programming
INTER-TEL
®
AXXESS
®
MANUAL VERSION 11.0 – May 2008
SQL Commands
PROGRAMMING
6
SQL Commands
10.26 To use the filtering option, a filter statement must appear in the “Specify A Filter” box.
The statement must be presented in SQL (Structured Query Language) format. SQL recognizes
the following operators:
10.27 The fields that are used to construct the SQL statement are provided in the Available
Fields list box. This box serves two purposes. First, it shows what fields can be used to con-
struct the SQL search statement and, second, it provides quick access to them. Double-click on
any of these fields and it will appear where the cursor exists in the Specify a Filter box.
SQL Statements
10.28 SQL commands and Available Fields are combined to construct a SQL expression. For
example, assume that you want to specify extension number 1234. The SQL expression to do
this is:
[extension] = “1234”
10.29 Note that the “extension” field to be searched is in square brackets. The value to be
matched in that field (the number 1234), is placed in quotes. The spaces on either side of the
equal sign are not required but help make the statement easier to read.
10.30 To place this expression into the Specify a Filter box, you can place the cursor in the
box and type the expression. Or, you can place the cursor into the Specify a Filter box, then
point at and double-click the desired field in the Available Fields box. This will cause the field
to appear at the cursor location in the filter specification box. At that point, you type the
remainder of the expression. If
Next is pressed, the system will present a new box showing any
phone with an extension of 1234. Remember that the device selected (keyset) was specified in
the Select Types To Include box.
Table 6-7: SQL Operators
< Less than
<= Less than or equal to (order of symbols must be correct)
= Equal to
>= Greater than or equal to (order of symbols must be correct)
> Greater than
BETWEEN A value that is greater than or equal to a specified lesser value and less than
or equal to a specified greater value. For example 3, 4, 5 and 6 are BETWEEN
3 and 6.
NOT Negates a statement.
IN Same as OR
AND Boolean operation indicating that two statements must both be true
OR Boolean operation indicating that either of two statements must be true
? Wildcard character for a single character
* Wildcard character for any number of characters
LIKE Used for equalities that are not exact matches. See text for examples.
To Next Page
Loading...
