[asterisk-users] MySQL Query : Calls Answered for < 5 sec

Warren Selby wcselby at selbytech.com
Fri Sep 14 11:37:30 CDT 2012

On Fri, Sep 14, 2012 at 11:33 AM, RSCL Mumbai <rscl.mumbai at gmail.com> wrote:

> @Raj
> I tried your query and variation by using replacing duration with billsec.
> In both cases, I get results including disposition "NO ANSWER"

If you don't want the "NO ANSWER" disposition, add an AND NOT DISPOSITION =
'NO ANSWER' to your query.  This is all pretty basic SQL Query writing, not
specific to asterisk...

--Warren Selby, dCAP
http://www.SelbyTech.com <http://www.selbytech.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120914/c7e07be6/attachment.htm>

More information about the asterisk-users mailing list