We are using IPCC Express 4.0.4 at one of our customer place and we are struck at one place with fetching the data from database.
Customer is using Oracle database and one tables for employee details and they have three types of employees.
1) Contractors - Starts with X than 6 numeric eg X047813
2) Suppliers - Starts with S than 6 numeric numbers eg S047813
3) Regular employees - Contains six numeric numbers eg 047813
There is no uniqueness between the employee 6 Numeric numbers it can overlap following C and X. And as they have only one table which is handling all the information, its kinda difficult for us to figure our the way to do this.
The call flow would be.
Someone calls in at the main number and we ask to press 1 if you are Contractor, press 2 if you are Supplier and Press 3 if you are Regular Employee.
Or Press one if you are Supplier or Contractor and Press 2 for regular Employee. After press one submenu says Press 1 for Supplier and Press 2 for Contractor. and than 6 digit numeric value.
Question is how we can achieve this using limited functionalities of IPCC express with queries of database. How we can collect the Alphanumeric(X or C) and than numeric(6 digit) and than goto database with the complete information and query the database.
Or What we are thinking is to store X/C/nothing in one variable. and store the employee input in second variable.
But how to use these two variables in DB node in query?, if we dont give variables in DB node it works by defining the values in query but not otherwise.
If Contractors always begin with an 'X' and Suppliers always begin with an 'S', and you are asking the caller whether they are Contractors, Suppliers or Regular Employees, then following these responses you should be able to prepend an 'X' or an 'S' to the 6-digit string, before you pass the string to the database query.
The Get Digit String will store the digits in a string variable. You can then use the "+" operator to concatenate the string. See attached code fragment which demonstrates the idea.
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...