Installation guide

Using custom database queries in Call Classifier rules 26-17
Chapter 26: Using the Call Classifier
Wave Global Administrator Guide
Note that when you query an SQL database, you can merge multiple fields. For
details, see “Merging multiple SQL data fields into a single result field” on page
26-20.
•
For a query or stored procedure. Enter the name of your custom stored procedure
or query, for example “myStoredProcedure”. The name must match exactly for the
query to work.
9 Enter the following fields:
•
Result fields. Enter the names of the fields that are returned by your query, for
example an address to display as Call Notes and an extension to which to transfer the
call. You can return as many fields as you want.
•
Load Fields. Click to execute the query and retrieve the names of all fields returned
by the query. You will use these field names later to set or change call values (as
described in “Attaching the query results to the call as data” on page 26-18.
•
No result text. Enter the text message that you want to return when no match is found
in your database.
Release 2.0
September 2010