We would like to create the custom Database query Reports for our customer without the using the SQL procedure. To create the SQL query's we use the SQuirreLSQL app and all our scripts are running successfully directly with no any problems. But if we move the script to the CUIC to create the custom report the problem with the creating fields arise. For example we create the following script with Select in Select:
SELECT DISTINCT ContactCallDetail.contactdisposition AS ContactDisposition, ContactCallDetail.contacttype AS contactType, ContactCallDetail.startdatetime AS StartDateTime, ContactCallDetail.enddatetime AS EndDateTime, ContactCallDetail.originatordn AS OriginatorDN, ContactCallDetail.destinationdn AS destinationDN, ContactCallDetail.applicationname AS ApplicationName, ContactCallDetail.originatortype AS OriginatorType, ContactQueueDetail.queuetime AS queuetime, (SELECT MIN(ccd.StartDateTime) FROM ContactCallDetail AS ccd, agentconnectiondetail WHERE ccd.destinationdn = ContactCallDetail.originatordn ) as isCalledToday FROM ContactCallDetail LEFT JOIN ContactQueueDetail ON ContactCallDetail.sessionid = ContactQueueDetail.sessionid
This script run successfully directly in the Database and in the CUIC without the second Select (highlighted). But with the second select the Field isCalledToday can not be created as expected and CUIC use the all second Select query as the Field.
Please see the attached screenshots for the more details.
Could you please to advice me the correct format for the query?
I want to find out how many agents are configured for an attribute. I have followed all the steps which are provided by the Cisco UCCE 11.6 API guide but I could not get the count. Is it possible to get a count of agents or not?
Collaboration Management Knowledge Base
For one-on-one help with these products, you can open a ticket at https://developer.cisco.com/site/support/. For other products, please contact Cisco TAC at https://www.cisco.com/c/en/us/support/index.html
Lately I have received a few requests from people asking if it was possible to Archive a Webex MessageSpace as in "download all messages".Interesting.
You can download all messages using the messages API but that leaves yo...
On May 10th 2021 a new API component was added: SPACE Tabs!
We call them ROOM tabs to be consistent with the room (space) API. Room Tabs represent an always available tab that is added as a tab in the space. It is co...
In a previous article I talked about the Cards & Buttons functionality of Webex Message. It's great to send nicely formatted or interactive messages.
What if you want to learn about Cards? There is a bot that teaches you all about Cards using...