Owner manual

Route By Query Result
26 Advanced Call Router Manual
Example: Multiple Tables
In this example, assume we have two tables: RouteTable for route
information and AgentTable for agent information. Here are the fields in the
RouteTable table:
Field Name Field Type Description
ProductNumber Text
Source data that Advanced Call Router
will search
for. The caller could enter this
string through the Auto Attendant.
Destination Text
The destination to which the call will be
rout
ed.
Here is an example of the data in this table:
Product Number Destination
5001 1001
5002 1002
5003 1003
Here are the fields in the AgentTable table:
Field Name Field Type Description
Destination Text The transfer destination.
Extension Text The destination extension number.
Priority Number The call priority.
Skill Number The required skill level for the agent.
Here is an example of the data in this table:
Destination Extension Priority Skill
1001 101 1 4
1002 102 3 5
1003 103 5 6
Both tables have a "Destination" field, which will be used to link records of
the two tables.