• V20: 3CX Re-engineered. Get V20 for increased security, better call management, a new admin console and Windows softphone. Learn More.

Call Statistics report.

Status
Not open for further replies.

DKar

Joined
May 29, 2009
Messages
3
Reaction score
0
Hi.

How do you get “Calls” column values in Call Statistics report?
In Calls Statistics’ Calls Filter I’ve selected
Period=From: ’date1’ to: ‘date2’;
Source=’extNumber’
Destination =’Any’
Calls =’All’
After which the value of “Calls” column I’ve gotten 33 calls. But If I wrote following query
SELECT COUNT (*)
FROM callhistory3
WHERE (callerid=' extNumber ' or from_no = 'extNumber ' or to_no = 'extNumber ' or dialednumber = 'extNumber ') and endtime >= ‘date1’ and starttime <= 'date2'
I don’t get 33 calls.
Question: What is wrong in my query?
 
Several spam posts were deleted - sorry for incovenience.
vali
 
Status
Not open for further replies.

Getting Started - Admin

Latest Posts

Forum statistics

Threads
141,626
Messages
748,910
Members
144,738
Latest member
Ghisl1
Get 3CX - Absolutely Free!

Link up your team and customers Phone System Live Chat Video Conferencing

Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.

3CX
A 3CX Account with that email already exists. You will be redirected to the Customer Portal to sign in or reset your password if you've forgotten it.