Hello all,
I have a problem how to tell the JPAContainer to group by x.
My table structure is like this:
[font=courier new]
| centre | receiptId | receiptPos | booking_date | price |
|---|---|---|---|---|
| 000001 | 123828289 | 0000000001 | 26.11.2013 | 123.00 |
| 000001 | 123828289 | 0000000002 | 26.11.2013 | 10.99 |
| 000001 | 123828289 | 0000000003 | 26.11.2013 | 10.99 |
| 000001 | 123828289 | 0000000004 | 26.11.2013 | 100.00 |
| 000001 | 789878755 | 0000000001 | 25.11.2013 | 123.00 |
| 000001 | 789878755 | 0000000002 | 25.11.2013 | 1231.00 |
| 000001 | 789878755 | 0000000003 | 25.11.2013 | 00.90 |
| 000001 | 789878755 | 0000000004 | 25.11.2013 | 15.90 |
| 000001 | 789878755 | 0000000005 | 25.11.2013 | 13.90 |
Centre, receiptId, receiptPos, booking_date as Composite Primary Key
Now I need JPAContainer to Group By: centre, receiptId, booking_date. And I need sum(price) in the Table.
How can I do this?
Thanks for your help.
[/font]