Вам нужно написать собственный запрос, this .
@Query(value =
"SELECT * FROM user_metric UM WHERE UM.user_id = :userId AND UM.metric_id = :metricId LIMIT :limit", nativeQuery = true)
List findTopNByUserIdAndMetricId(
@Param("userId") String userId, @Param("metricId") Long metricId,
@Param("limit") int limit);
for (var i = 0; i < 5; i++) {
var ii = i + 1;
this["date" + ii] = this.data[i].Date;
this["tempMax" + ii + "V"] = this.data[i].Temperature.Maximum.Value;
this["tempMax" + ii + "U"] = this.data[i].Temperature.Maximum.Unit;
this["tempMin" + ii + "V"] = this.data[i].Temperature.Minimum.Value;
this["tempMin" + ii + "U"] = this.data[i].Temperature.Minimum.Unit;
this["day" + ii] = this.data[i].Day.IconPhrase;
this["night" + ii] = this.data[i].Night.IconPhrase;
}