Installation guide

Using custom database queries in Call Classifier rules 26-16
Chapter 26: Using the Call Classifier
Wave Global Administrator Guide
• Query name. Enter the name of your query, for example “CallerID Query”. The
name must match exactly for the query to work.
•
Input parameter. Enter the name of the input parameter expected by your query,
for example “PhoneNumber”. The name must match exactly for the query to
work.
Go to step 9.
•
SQL query or stored procedure. With this option, the Call Classifier queries your
database using a dynamic SQL query that you specify here, or a custom stored
procedure or query within the database. If the latter, you must first create the stored
procedure or query, as described in “Setting up a stored procedure or query in your
database” on page 26-20.
Enter the
Query text:
•
For a dynamic SQL Query. Enter your SQL Select statement. Insert the string
|CC_Input| where the input data will go, as in the following example:
SELECT Field2, Field3 FROM Table1 WHERE Field1 = ‘|CC_Input|’
Release 2.0
September 2010