Welltech SIPIVR 6800GS V.2.1 - Manual (Page 128)

127
Mapping
○ Alias Name:TestDb
○ Field Name: User Phone Number
○ Variable Name:TestValue3
○ Clear Mapping:(Check this box)
○ Next Goto:1005
○ Error Goto:1007
SQL
Execute
1005
Execute SQL Command. User Name ='001' and
Passwd ='001'.
○ Alias Name:TestDb
○ Execute Now:(Check this box)
○ SQL Command: select User Phone Number from
User Data where User Name = '$$TestValue1$$'
and Passwd = '$$TestValue2$$'
○ Success Goto:1008
○ Error Goto:1007
○ Not data Goto:1007
Play
Announcement
1008
Execute command result, play message (Value
“TestValue3”)
○ Var: (Check this box)
○ Message:TestValue3
○ Delay Interval: 0
○ Message Content: Text
○ Error Goto:1006
○ Next Goto:1006
SQL
Fetch
1006
Retrieve next data from database (Test Db)
○ Alias Name:TestDb
○ Retrieve Mode: Next
○ Not data Goto:1007
○ Success Goto:1008
○ Error Goto:1007
On Hook
1007
Hang up the Line
Example of Used Call Flow: