Skip to content

Instantly share code, notes, and snippets.

@rvencu

rvencu/call_history.sql

Created September 23, 2020 09:24
Show Gist options
  • Save rvencu/6861c5edca1276588838226aa04f97be to your computer and use it in GitHub Desktop.
Save rvencu/6861c5edca1276588838226aa04f97be to your computer and use it in GitHub Desktop.
Download ZIP
SQL command to retrieve call history from 3CX database
Raw
call_history.sql
select C.*, PS.caller_number as Caller, PD.caller_number as Destination from cl_calls C
JOIN cl_segments S ON C.id = S.call_id
JOIN cl_party_info PS ON PS.id = S.src_part_id
JOIN cl_party_info PD ON PD.id = S.dst_part_id
where S.seq_order = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment