Call details mismatch

[Sanjay Pandey]

We are using custom built crm. So, we try to fetch extension wise inbound/outbound call detail from 3cx table “cdroutput” directly. But the data fetched from the 3cx table is not matching with data exported from 3cx dashboard.

Example query:

-------------------------------------------------------------- inbound
SELECT * FROM cdroutput where
date(cdr_answered_at) ='2025-12-04'
and destination_dn_number ='5007'
--and source_entity_type='external_line'
--and destination_entity_type='external_line'
------------------------------------------------------------- outbound answered
SELECT * FROM cdroutput where
date(cdr_answered_at) ='2025-12-04'
and source_dn_number ='5007'
and destination_entity_type='external_line'
------------------------------------------------------------- outbound not answered
SELECT * FROM cdroutput where
date(cdr_started_at) ='2025-12-04'
and cdr_answered_at is NULL
and source_dn_number ='5007'
and destination_entity_type='external_line'