topic SUM and AS support for UCCX Script in DevNet General Discussions

SUM and AS support for UCCX Script

Imran Khan — Fri, 01 Mar 2019 10:45:54 GMT

We have a customer who have database dips setup between UCCX and SQL Server. Everthing is working fine but they are trying to run a query which has SUM and AS in the query. When I run the query, I see the correct results but when I try to set the field which is been summed, it goes into SQL Error branch. I was wondering if that is supported. The query is as follows.

SELECT account_no, occupant_code, SUM(a.trans_amt) AS Total FROM pu_balance_hist a WHERE account_no = '12345' AND a.occupant_code = '12' AND trans_type in ( 'N','I') AND a.trans_date >= ( CONVERT (date, getdate()-365)) GROUP BY a.account_no, a.occupant_code,a.trans_date

Re: SUM and AS support for UCCX Script

Geevarghese Cheria — Wed, 17 Sep 2014 12:23:49 GMT

I think this could be issue with Executing a MS SQL Stored Procedure. Its not related to SUM . I would request you to refer the following url Executing a MS SQL Stored Procedure - UCCX 8 | Contact Center | Cisco Support Community | 5926 | 11172061 for related information.

Thanks and Regards,

Geevarghese

Re: SUM and AS support for UCCX Script

Samuel Womack — Wed, 17 Sep 2014 21:20:11 GMT

Without knowing anything about what your Field Select tab looks like in your DB Get Step..ensure the Variable you are trying to set is the Data Type the DB is returning..