<font face="verdana,sans-serif">I need a list of calls Answered and Disconnected in less than 5 sec.<br><br>Thx<br><br><br></font><br><div class="gmail_quote">On Fri, Sep 14, 2012 at 10:07 PM, Warren Selby <span dir="ltr"><<a href="mailto:wcselby@selbytech.com" target="_blank">wcselby@selbytech.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im"><div class="gmail_quote">On Fri, Sep 14, 2012 at 11:33 AM, RSCL Mumbai <span dir="ltr"><<a href="mailto:rscl.mumbai@gmail.com" target="_blank">rscl.mumbai@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<font face="verdana,sans-serif">@Raj<br><br>I tried your query and variation by using replacing duration with billsec.<br>In both cases, I get results including disposition "NO ANSWER"</font><br></blockquote></div>
<br><br></div>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...<span class="HOEnZb"><font color="#888888"><br clear="all">
<br>-- <br>Thanks,<br>--Warren Selby, dCAP<br><a href="http://www.selbytech.com" target="_blank">http://www.SelbyTech.com</a><br><br>
</font></span><br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br>