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.
