[FIXED] How to get an average int for a Collection of an Entity using thymeleaf?

Issue

I have an Employee Entity that has a Collection of Reviews, each Review has a byte grade.

Unnecessary details are omitted for brevity

@Entity
public class Employee extends AbstractBaseEntity {
    @OneToMany( mappedBy = "employee",  cascade = CascadeType.MERGE, fetch = FetchType.LAZY)
    private List<Review> reviews;
}
@Entity
public class Review extends AbstractBaseEntity {
    private Byte grade;
}

How can I get an average Review grade for each Employee using Thymeleaf to insert in Table?

Solution

Thymeleaf has aggregate functions. You can combine them with collection projection.

<span th:text="${#aggregates.avg(employee.reviews.![grade])}" />

Answered By - Metroids
Answer Checked By - Marie Seifert (JavaFixing Admin)