06-15-2016 11:39 AM - edited 03-14-2019 04:14 PM
we are trying to gather the expected wait time for a CSQ directly from the CCX database to announce back to a 3rd party app.
what are the database tables I need to gather to do that ? I have the database schema document but I'm not sure what tables to grab to make my calculation.
Thanks in advance for your help
Solved! Go to Solution.
06-16-2016 10:16 AM
You will not be able to get/query the Expected Wait Time directly from any table. The closest you can do is to query RTCSQsSummary and RtICDStatistics tables to get Average Wait Duration and then do your own calculation, this is what UCCX Engine only does as well
Regards
Deepak
06-16-2016 10:16 AM
You will not be able to get/query the Expected Wait Time directly from any table. The closest you can do is to query RTCSQsSummary and RtICDStatistics tables to get Average Wait Duration and then do your own calculation, this is what UCCX Engine only does as well
Regards
Deepak
07-14-2016 12:41 PM
Do you know what fields I grab and what the calculation is ?
07-26-2016 03:26 PM
I was able to gather it up.
in the RTCSQsSummary Table grab the following fields
(CALLSWAITING +1 ) * AVGTALKDURATION / (WORKINGAGENTS + TALKINGAGENTS + RESERVEDAGENTS)
if this appears to be incorrect let me know
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