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