cancel
Showing results for 
Search instead for 
Did you mean: 
cancel

CCX editor scripting SQL Query $ not as variable but part of name

klueting
Beginner
Beginner

Dear Ladies and Gentlemen,

 

we are trying build a script for the UCCX using the Cisco Unified CCX Editor.

 

But when it comes to the SQL query (we need to connect to our database and get some information out of it) we have a problem, because in our database we have the tables named like "$ServiceHeader" and the "$" is the problem here ... because the Editor thinks we want to declare a variable but its just part of the name of the table ... we tried masquerading the $ in different ways but with no success.

 

Do you have any ideas how to avoid the editor thinking its a variable and telling the editor its just a part of the tables name?

 

Thank you very much in advance.

2 REPLIES 2

Roger Kallberg
VIP Mentor VIP Mentor
VIP Mentor

Not very sure on this, but as the system is pretty much Java based it could work by following what is outlined in this link.



Response Signature


Elliot Dierksen
VIP Collaborator VIP Collaborator
VIP Collaborator

I guess my first question would be why you put special characters in a table name? Failing that, you could always create a single table view in the DB that doesn't have special characters in the name to avoid the problem.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: