Problem with UCCX Substring

[scr.sybex1]

Dear Sir,

I have Problem With UCCX Substring Method. the problem is that in first scenario that i attach it's picture i have no problem when i compare the variable with the field that i use in SQL Server 2012 DB, But in Second Scenario I have problem with substring method that i used for string variable to get the digit that i want there. when i used substring method to do that, i can not match that value to the value of DB Field

Thanks

[Bill Mungaven]

You can try adding a new variable called areaCode and using the Set step to set areaCode = CallerID.substring(0,4) instead of CallerID=CallerID.substring(0,4). In your SQL statement, change $CallerID to $areaCode and see if that makes any difference.

Bill

[scr.sybex1]

Thank for Respose

I do that but not work.

I even pass the value in that $areacode to the finesse agent with set enterprise call info and that show the correct value that i want. but when i want to use SQL Query that doesn't match the DB Field Value.

I think the problem should be one of the following:

1)Mismatch Data type

2)Wrong Driver For JDBC

3)Substring add somehing before or after the string manipulation

I don't Know what the Exact Problem with that.(Because the value in that field really match the SQL DB Field)