08-14-2024 08:55 AM
Hi All,
could anyone help me with the query where I can get total call count (number of calls hit the DN) monthly wise for the specific "DialedNumberString" from RCD or even from TCD also with "digitsdialed "
We have grouped multiple DNs and mapped single CallType so not a great visibility to see how many calls came to each DNs.
regards,
Kavle
08-14-2024 04:38 PM
You mean like
Select Count(DialedNumberString) as CountofCalls, DialedNumberString
from Route_Call_Detail
Group by DialedNumberString
There's obviously a lot more you might want to filter out by date and such but that's what you want?
08-14-2024 10:39 PM
yes sir , I have multiple DNs . I want to pass around 15 DNs into a single query and obtain the result of callcount .
I am trying with CASE clause to do it however not exactly getting what's the proper way.
08-15-2024 12:21 AM
Thanks, Bill, for the reply, I have figured out now.
08-15-2024 02:34 PM
How'd you do it, with a IN type statement I' guessing? Do you want to post how you did it here to benefit the next person?
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