How does myphone_callhistory_v14 link to callcent_queuecalls

[cloudland_jglasson]

We are working on an integration to pull call logs, however I can't find a column that contains a unique identifier that exists in both callcent_queuecalls and myphone_callhistory_v14.

Call Logs have call_id which is a sequential number but queuecalls have a call_history_id, how do I get the call_history_id from the myphone_callhistory_v14 table?

 

[Evolute IT]

You should not be accessing the database, therefore don't expect any help here. Even partners who are specialized in integrations (like us, @VoIPTools and @jed (and maybe more)), we know to not touch the DB.

You want call log? Use the CDR.

 

[cloudland_jglasson]

We are currently using CDR but it gives incorrect answer times for calls that are sent to queues. The only way I have been able to get that information it from the database or from a manual report which wont work for deploying to 100 or so client boxes