| 24 |
|
_reportField = "packet.cpu.user"; |
| 25 |
|
|
| 26 |
|
// Use this select query. |
| 27 |
< |
_sql = "SELECT * FROM packet_test pkt, parameter_test param WHERE pkt.id=param.packet_id AND pkt.machine_name='"+ _machine_name+"' AND pkt.receipt_date >= "+_startDate+" AND pkt.receipt_date <= "+_endDate+" AND param.name='"+_reportField+"' ORDER BY pkt.receipt_date;"; |
| 27 |
> |
_sql = "SELECT receipt_date, value FROM packet_test pkt, parameter_test param WHERE pkt.id=param.packet_id AND pkt.machine_name='"+ _machine_name+"' AND pkt.receipt_date >= "+_startDate+" AND pkt.receipt_date <= "+_endDate+" AND param.name='"+_reportField+"' ORDER BY pkt.receipt_date;"; |
| 28 |
|
|
| 29 |
|
} |
| 30 |
|
|