Get Result from Stored Procedure SQL to local variable UCCX Editor

[moka1812]

Hello all,

I'm newbie in UCCX Editor.

I have a Stored procedure (SP) . That SP return int value (0 or 1 or 2). I want to get it to local variable in UCCX Editor. Then use if condition to check this local variable 
How can i do it ?

Thanks all

[Vinod Patil]

Go through the scripting guide volumn1 chapter 11 to use the external DB with UCCX

https://www.cisco.com/c/en/us/support/customer-collaboration/unified-contact-center-express/products-programming-reference-guides-list.html

[Simon Edwards]

This document doesn't (as far as I can tell) make any reference to Stored Procedures.

[rastetterj]

Simon,

Did you ever get this to work?  Were you able to get back a variable from the stored proc?