<HTML>
<HEAD>
<TITLE>CDRTool date query problem</TITLE>
</HEAD>
<BODY>
<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>
</BODY>
</HTML>