Change to this: select * from cdr where calldate >= '2012-09-01' and calldate < '2012-09-08' and duration < 5 and disposition<>’NO ANSWER’;
From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of RSCL Mumbai Sent: Friday, September 14, 2012 11:34 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] MySQL Query : Calls Answered for < 5 sec @Raj I tried your query and variation by using replacing duration with billsec. In both cases, I get results including disposition "NO ANSWER" On Fri, Sep 14, 2012 at 9:58 PM, Raj Mathur (राज माथुर) <r...@linux-delhi.org> wrote: On Friday 14 Sep 2012, RSCL Mumbai wrote: > I am trying to construct MySQL query(s) to get a list of calls which > lasted for less than 5 seconds between a given date range. > Any help is appreciated. On the CDR database, to get all calls that lasted < 5 seconds between 2012-09-01 and 2012-09-07 (inclusive), the MySQL query would be: select * from cdr where calldate >= '2012-09-01' and calldate < '2012-09-08' and duration < 5; Regards, -- Raj -- Raj Mathur || r...@kandalaya.org || GPG: http://otheronepercent.blogspot.com || http://kandalaya.org || CC68 It is the mind that moves || http://schizoid.in || D17F -- _____________________________________________________________________ -- 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