Installation guide

Using custom database queries in Call Classifier rules 26-18
Chapter 26: Using the Call Classifier
Wave Global Administrator Guide
10 In the Test Query section, verify that the query works using the following fields:
•
Sample value. Enter a sample input parameter.
•
Test!. Click to test the query.
•
Test result. Displays the result of the query.
If the test query does not succeed, check syntax and spelling. For a stored query or
procedure, make sure that the spelling of the Input parameter and each Result field is
exactly the same as in the database procedure.
When you have verified that the query works, click
OK to return to the Add Rule dialog.
Note: After creating a Call Classifier rule that uses an MS Access custom database query,
unexpected text may be displayed in the text box below the Condition in the Add Rule
dialog. This behavior occurs for any defined condition, as in the following example. This
unexpected text is harmless and does not affect the Call Classifier rule in any way.
11 To finish adding this rule, go to step 6 on page 26-8.
Attaching the query results to the call as data
You can choose to attach one or more of a database query’s
Result fields (as specified in the Edit
Database Query dialog) to the call. Any information already in a field (such as a Caller ID
number) will be overwritten when this rule executes.
Release 2.0
September 2010