Assistance Required for Generating Missed Call Report

[vivasupport]

Dear Support,

Our customer has requested a report showing only the abandoned or missed calls for the entire day.


For example, if a call from 0123456789 at 09:00 was missed but another call from the same number at 15:00 was answered, it should not appear in the missed call report. However, if both calls were unanswered, then it should be listed as a missed call.


We are attempting to create this report using the CDR output, but we are unable to script the query successfully. Could you please assist us in generating the report by comparing the answered and missed call data to produce results showing only missed calls for the day?


Kindly share the appropriate script or advise which table names we should use for comparison.

Regards,
Diravin

 

[KyriacosS_3CX]

Pseudo code:

Select * from all_calls where in_date_range and type=external and status=missed
and caller not in ( Select caller from all_calls where in_date_range and type=external and status=answered)

Something along these lines should give you the data you need.