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

[Warren Selby]

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...

-- 
Thanks,
--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>