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.
OR is there any other way we can do this?
Thanks in Advance!