2 major things!!!!!:
In Call Journaling to Mysql database:
1) Outbound calls with @CallType=Notanswered dont is loged in CallJournaling
-I think its becouse the variable @CallEstablishedTimeLocal does not exist
-Plot twist: I cant make even a "CASE WHEN" in the insert SQL to verify the @CallEstablishedTimeLocal exist, if i place this variable in my Insert, 3CX dont even execute it.
- Nothing shows in Log, even in Verbose mode. Nothing with "CRM" "Report" "CallEstablished..."
2) I use Queues to answer calls by a good reason, but the variable @Duration is contamined with ringing time!!!!
- @Duration is adding Ringing Time + Duration Call (Yes, I know the behavior of queue is to pick a call when it rings, but in REPORT CALLs menu 3CX shows the right duration! Then why do that in @Duration of Call Journaling?
- You can tell me: "get the @CallStartTime and @CallEstablishedTime and subtract to get the correct Duration". But remember, I took out the @CallEstablishedTime from my SQL insert becouse it was making 3CX DO NOT LOG ANY OUTBOUND CALL NOT Notanswered.
If 3CX correct the @Duration of calls receive in queues. That problem would be solved. Becouse I dont need the @CallEstablishedTime anymore.
ANY IDEA?
In Call Journaling to Mysql database:
1) Outbound calls with @CallType=Notanswered dont is loged in CallJournaling
-I think its becouse the variable @CallEstablishedTimeLocal does not exist
-Plot twist: I cant make even a "CASE WHEN" in the insert SQL to verify the @CallEstablishedTimeLocal exist, if i place this variable in my Insert, 3CX dont even execute it.
- Nothing shows in Log, even in Verbose mode. Nothing with "CRM" "Report" "CallEstablished..."
2) I use Queues to answer calls by a good reason, but the variable @Duration is contamined with ringing time!!!!
- @Duration is adding Ringing Time + Duration Call (Yes, I know the behavior of queue is to pick a call when it rings, but in REPORT CALLs menu 3CX shows the right duration! Then why do that in @Duration of Call Journaling?
- You can tell me: "get the @CallStartTime and @CallEstablishedTime and subtract to get the correct Duration". But remember, I took out the @CallEstablishedTime from my SQL insert becouse it was making 3CX DO NOT LOG ANY OUTBOUND CALL NOT Notanswered.
If 3CX correct the @Duration of calls receive in queues. That problem would be solved. Becouse I dont need the @CallEstablishedTime anymore.
ANY IDEA?
