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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.