| 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+"';"; |
| 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 |
|
|
| 31 |
|
//---PUBLIC METHODS--- |
| 32 |
|
|
| 33 |
|
// Override the superclass here to obtain special functionality. |
| 34 |
< |
//public void createReport(){ |
| 34 |
> |
public void createReport(){ |
| 35 |
|
|
| 36 |
< |
// Activate special funtionality. |
| 37 |
< |
|
| 36 |
> |
// Perform special functions here. |
| 37 |
> |
// ..... |
| 38 |
|
|
| 39 |
|
// Now carry on with the normal method for creating reports. |
| 40 |
< |
// super.createReport(); |
| 41 |
< |
//} |
| 40 |
> |
super.createReport(); |
| 41 |
> |
} |
| 42 |
|
|
| 43 |
|
//---PRIVATE METHODS--- |
| 44 |
|
|