<HTML>
<HEAD>
<TITLE>Re: [OpenSIPS-Users] CDRTool date query problem</TITLE>
</HEAD>
<BODY>
<FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Adrian,<BR>
<BR>
I completely missed that. Wow. It appears the misconfiguration was between the keyboard and chair.<BR>
<BR>
<BR>
- Jeff<BR>
<BR>
<BR>
<BR>
On 5/4/09 10:36 AM, "Adrian Georgescu" <<a href="ag@ag-projects.com">ag@ag-projects.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Jeff,<BR>
<BR>
The search screen clearly displays a list of monthly tables. You should select the table you want, 200904 in this case.<BR>
<BR>
Adrian<BR>
<BR>
On May 4, 2009, at 4:34 PM, Jeff Pyle wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><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>
<BR>
</FONT><FONT FACE="Tahoma, Verdana, Helvetica, Arial"> 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>
<BR>
</FONT><FONT FACE="Tahoma, Verdana, Helvetica, Arial"> 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>
<BR>
_______________________________________________<BR>
Users mailing list<BR>
<a href="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>
</FONT></SPAN></BLOCKQUOTE><SPAN STYLE='font-size:10pt'><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><BR>
<BR>
</FONT></SPAN></BLOCKQUOTE>
</BODY>
</HTML>