Line Time Query
This MySQL query can be used to look up the SpitFire software's LineTime value from the Calls table of a list.Note that 214 is the name of the list and the time stamp is for all calls made on 3/25/08.
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) FROM `214`.calls where starttime between '2008-03-25 00:00:00' and '2008-03-25 23:59:59'
Related Articles
- Custom Query in SpitFire
- Deleting Lists in SpitFire Pro (MySQL Version)
- Names Not Showing on SpitFire Agent Software
- List Won't Import (ListMaker Pro)
- SpitFire Predictive Pro Campaign Preferences
Attachments
No attachments were found.Visitor Comments
No visitor comments posted. Post a commentPost Comment for "Line Time Query"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.Article Details
Last Updated
6th of July, 2009
