10-26-2017 01:43 AM
Hi
We have been testing custom reports in CUIC to report on UCCX call stats. Daily reports seem to be working fine giving accurate information and we can sort by date ascending in the reporting front end without any issues.
The problem is we are trying to create time interval based reports. I am able to pull the data I need but any 'Order By' clause seems to be ignored and the only way this report will be useful is if we can have a multi level sort to first sort by hour and then intervals of 10 mins which the front end doesn't support as you can only sort 1 column at a time.
As a test I tried to make this as simple as possible:
select
contactcalldetail.sessionID as Testing
from
contactcalldetail
ORDER BY Testing
In the above example the output list of session IDs is not ordered. I have tried to cast the session ID into different formats thinking it could be a strange data type that doesn't sort but nothing I do seems to let me sort the output. Has anyone had similar issues?
10-26-2017 02:02 AM
hi William,
Can you please let me know what version of CUIC/UCCX is being used here?
Thanks,
Vikram G
10-26-2017 03:16 AM
Hi Vikram
UCCX 11.5
CUIC 11.5
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