Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

Call Statistics report.

Discussion in '3CX Phone System - General' started by DKar, May 30, 2009.

Thread Status:
Not open for further replies.
  1. DKar

    Joined:
    May 29, 2009
    Messages:
    3
    Likes Received:
    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?
     
  2. Vali_3CX

    Vali_3CX Well-Known Member
    Staff Member 3CX Support

    Joined:
    Dec 12, 2008
    Messages:
    1,528
    Likes Received:
    71
    Several spam posts were deleted - sorry for incovenience.
    vali
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Thread Status:
Not open for further replies.