I have a requirement from a customer, need to check the customers CLIDs in their DB and then route their calls to specific agents directly.
i have made DB with 2 columns having all the required customer's CLIDs with the AgentID to whom their call should route and using a DB LookUp Node in script to check the CLI in the Table it gets fail. the dbworker process logs show Db connected but "Failed ! result=1" or some times "Failed result=6". but if i used a table having only one coulmn containing CLIDs this method works.
Is there any speceifc method to access the DB having more than one Column. I need to access and use both the columns.