I need a list of calls Answered and Disconnected in less than 5 sec. Thx
On Fri, Sep 14, 2012 at 10:07 PM, Warren Selby <wcse...@selbytech.com>wrote: > On Fri, Sep 14, 2012 at 11:33 AM, RSCL Mumbai <rscl.mum...@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> > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users