SpitFire Help Desk



Connect Time by Date

This can be used to view only the LineTime for only those calls that connected to a voice, answering machine or fax.
So this would exclude any no answers, busies and operator intercepts.
Note that the name of the list is 214
Also, the SpitFire LineTime is an internal calculation that starts at the moment one of the Dialer's lines goes off-hook to dial the number and ends when the line is disconnected. Ring time is included.

SELECT sum(LineTime) as `Total Seconds`, count(*) as `Call Count` FROM `001test`.`calls` where StartTime like '2008-01-21%' and (result='201' or result='202' or result='203');


Related Articles

Attachments

No attachments were found.

Visitor Comments

No visitor comments posted. Post a comment

Post Comment for "Connect Time by Date"

To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.

   Name:
   Email:
* Comment:
* Enter the code below:

 

Article Details

Last Updated
6th of July, 2009

Would you like to...

Print this page  Print this page

Email this page  Email this page

Post a comment  Post a comment

 Subscribe me

Subscribe me  Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF


User Opinions

No users have voted.

How would you rate this answer?




Thank you for rating this answer.

Continue