из .jrxml отчета
Код: <queryString language="BGBS"><![CDATA[//select login_name, session_start, session_stop, session_time, session_cost, input_octets/1048576.0, output_octets/1048576.0, from_number, inet_ntoa(ipaddr), status FROM log_session_1_200806 WHERE session_start BETWEEN '2008-06-01' AND '2008-06-05' limit 0,100
import java.sql.*;
import java.util.*;
public void fillReport( con, filter, result )
{
PreparedStatement ps ;
if ( filter.getStringParam("status").equals("3") )
{
ps = con.prepareStatement(
result.sql( "select login_name, session_start, session_stop, session_time, session_cost, input_octets/1048576.0, output_octets/1048576.0, from_number, inet_ntoa(ipaddr), status FROM log_session_1_$yy(month)$mm(month) WHERE session_start BETWEEN '$date(month)' AND '$date(days)' AND $(filter) like '%$(value)%' order by $(sort) $(order) limit 0,$(limit)", filter ) );
}
else
{
ps = con.prepareStatement(
result.sql( "select login_name, session_start, session_stop, session_time, session_cost, input_octets/1048576.0, output_octets/1048576.0, from_number, inet_ntoa(ipaddr), status FROM log_session_1_$yy(month)$mm(month) WHERE session_start BETWEEN '$date(month)' AND '$date(days)' AND $(filter) like '%$(value)%' AND status=$(status) order by $(sort) $(order) limit 0,$(limit)" , filter ) );
}
ResultSet rs = ps.executeQuery();
result.setDataSource( rs );
}]]></queryString>
|
потому как другие mysql функции работают. Алиасы при этом не помогают спрятать inet_ntoa
