02-03-2015 08:32 AM - edited 03-14-2019 02:24 PM
Hello,
I have reviewed at length the posted schema and query information for the UCCX database. I was hoping someone could review my query below and let me know if I am missing anything. I am trying to get a count of all calls presented for today so far (grouped by csq). Thanks in advance for the help.
SELECT contactservicequeue.csqname,
contactqueuedetail.profileid, contactqueuedetail.targetid, COUNT(distinct contactcalldetail.sessionid)
AS [Calls Presented]
FROM UCCX.db_cra.informix.contactcalldetail CROSS JOIN
UCCX.db_cra.informix.contactqueuedetail CROSS JOIN
UCCX.db_cra.informix.contactservicequeue
WHERE (contactcalldetail.sessionseqnum = contactqueuedetail.sessionseqnum) AND (contactcalldetail.sessionid = contactqueuedetail.sessionid) AND
(contactcalldetail.profileid = contactqueuedetail.profileid) AND (contactcalldetail.nodeid = contactqueuedetail.nodeid) AND (contactqueuedetail.targetType = 0) AND
(contactqueuedetail.targetid = contactservicequeue.recordid) AND (contactcalldetail.startdatetime >= CONVERT(date, GETDATE()))
GROUP BY contactqueuedetail.targetid, contactqueuedetail.profileid, contactservicequeue.csqname
09-02-2019 06:32 AM
Hi I am using following query extracted from UCCX stored procedure.
When I am running stored proceudre using CUIC output is correct and when I am standalone query using AGS server studio out data mismatch.
SELECT cqdr.targetid, csq.csqname, cqdr.profileid, Count(cqdr.sessionid)
, (Sum(cqdr.queuetime) / Count(cqdr.sessionid)), Max(cqdr.queuetime)
FROM Contactqueuedetail cqdr, Contactcalldetail ccdr, contactservicequeue csq
WHERE cqdr.sessionid = ccdr.sessionid AND
cqdr.sessionseqnum = ccdr.sessionseqnum AND
cqdr.profileid = ccdr.profileid AND
cqdr.nodeid = ccdr.nodeid AND
ccdr.startdatetime >= "2019-01-02 00:00:00.000" AND
ccdr.startdatetime <= "2019-01-02 23:59:59.999" AND
cqdr.targetid = csq.recordid AND
cqdr.targettype = 0
GROUP BY csq.csqname, cqdr.targetid, cqdr.profileid
order by csqname;
Contact center running morning 6 am tot 12 am.
Timezone is pacific standard time.
Regards,
Pravin
02-05-2015 09:06 AM
After 10 pm the phones go to voicemail. Staff comes in to take calls from 7 am on.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide