Apache Cayenne - Merge Data
Keena Grepo <[email protected]>
| Newsgroups | gmane.comp.java.cayenne.user |
|---|---|
| Message-ID | <pony-493149467983a110086d60fa5cc78360b328d806-67fd448bdd15a5c6bc346f711b845070af5cd1c0@user.cayenne.apache.org> |
Hi,
I have this data returned by ObjectSelect.columnQuery :
[{<ObjectId:UtilizationData, id=1>; committed; [hostname=>cc001; percentagePerHour=>100; timestamp=>2019-07-09 00:00:00]}, {<ObjectId:UtilizationData, id=2>; committed; [hostname=>cc001; percentagePerHour=>50; timestamp=>2019-07-09 01:00:00]}, {<ObjectId:UtilizationData, id=3>; committed; [hostname=>cc001; percentagePerHour=>50; ; timestamp=>2019-07-09 02:00:00]}, {<ObjectId:UtilizationData, id=4>; committed; [hostname=>cc001; percentagePerHour=>83; timestamp=>2019-07-09 03:00:00]}, ...]
And I want to display the data in a table with "HOST", and timestamps as table head. Then for the table data are the value of hostname and the percentagePerHour for each respective timestamp (like the sample table below). How can I achieve this?
-------------------------------------------------------------------------------------------------------------------------------
| HOST | 2019-07-09 00:00:00 | 2019-07-09 01:00:00 | 2019-07-09 02:00:00 | 2019-07-09 03:00:00 |
-------------------------------------------------------------------------------------------------------------------------------
| cc001 | 100 | 50 | 50 | 83 |
-------------------------------------------------------------------------------------------------------------------------------
By the way, I am using Springboot + Thymeleaf.
Thanks.