signaldawg
Technical User
I am trying to a simple db lookup in a script with 4 nodes(start, db lookup, (succeed)label, and (failure)label. Here is the scenario:
“Inbound call received from 800xxxxxx into ICM. A database dip is done into table (tablename)to match the inbound number with the ANI column in table and should return a true label to ATT_NIC.##########. I keep getting a false and it goes to label ATT_NIC.##########.” The tabel has 4 columns, ID (key), Site, ANI, and type. I want the inbound call to match the record in the table ANI and return a true lable to route to my Irving office. I can't change the key to the ANI column becasue i could have multiple sites with the same ANI. I have tried every possible formula and keep getting one these or 2 msgs:
DB Lookup #57
Key:
False; DBLookup failed. Error 1.
or
False:Expression returned invalid result.
“Inbound call received from 800xxxxxx into ICM. A database dip is done into table (tablename)to match the inbound number with the ANI column in table and should return a true label to ATT_NIC.##########. I keep getting a false and it goes to label ATT_NIC.##########.” The tabel has 4 columns, ID (key), Site, ANI, and type. I want the inbound call to match the record in the table ANI and return a true lable to route to my Irving office. I can't change the key to the ANI column becasue i could have multiple sites with the same ANI. I have tried every possible formula and keep getting one these or 2 msgs:
DB Lookup #57
Key:
False; DBLookup failed. Error 1.
or
False:Expression returned invalid result.