<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Jeff,<div><br></div><div>The search screen clearly displays a list of monthly tables. You should select the table you want, 200904 in this case.<div><br></div><div>Adrian<br><div><br><div><div>On May 4, 2009, at 4:34 PM, Jeff Pyle wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div> <font face="Tahoma, Verdana, Helvetica, Arial"><span style="font-size:10pt">Hello,<br> <br> In CDRTool v6.7.5, I have the following towards the top of my Opensips data source definition:<br> <br> </span></font><span style="font-size:10pt"><font face="Lucida Console">"table" => "radacct".date("Ym"),<br> </font><font face="Tahoma, Verdana, Helvetica, Arial"><br> This is per the instruction right there in the file, if I’m running the mysql procedure to auto-rotate tables. I am. The problem is that CDRTool appears to query only the current month and year.<br> <br> Today I tried to select records on April 28 from 16:00 to 16:30. A network capture of the traffic from CDRTool to the mysql server showed the following query:<br> <br> </font><font face="Lucida Console">select count(*) as records\n from radacct200905 where (AcctStartTime >= '2009-04-28 16:00' and AcctStartTime < '2009-04-28 16:30') <br> </font><font face="Tahoma, Verdana, Helvetica, Arial"><br> Queries looking for call in May work just fine, as one might expect. Is this a misconfiguration or a bug?<br> <br> <br> Thanks,<br> Jeff<br> </font></span> </div> _______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></blockquote></div><br></div></div></div></body></html>