08-07-2024 12:46 PM
I am trying to generate some custom reports for courtesy callback. My query is not working quite the way I though. I am trying to create a summary report that counts the number of pending callbacks that have zero retries.
We are using UCCE 12.6.
Here is the query from the report definition we are using. This only returns the date column though.
select
date(dbdatetime) as date,
cause,
count(*)
from callback_current cc
left join causeref cr on cr.causeid = cc.causeid
where date(dbdatetime) = '08-07-2024'
and date(dbdatetime) <= '08-07-2024'
and (cc.causeid = '0' and cc.eventtypeid = '21' and 'nbrattempts' = '0')
group by date, cause
order by date, cause
Also, does the community have any custom reports for courtesy callback that you would be willing to share? I have a few basic ones from Cisco but nothing that summarizes total number of pending callbacks, total number completed callbacks and the completion reasons.
08-07-2024 05:42 PM
Hi, did you start with the prebuilt ones that Cisco provides as part of the CUIC templates?
08-08-2024 05:13 AM
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