Skip to content
Snippets Groups Projects

Accélérer indicator/list

Merged Olivier Maury requested to merge accelerer-indicators-list into main
1 file
+ 1
1
Compare changes
  • Side-by-side
  • Inline
@@ -253,7 +253,7 @@ public class PraDailyValueDaoHibernate extends DaoHibernate<PraDailyValue> imple
@Override
public final List<Indicator> findIndicators(@NonNull final Integer year) {
final var sql = "SELECT DISTINCT indicator FROM dailyvalue WHERE EXTRACT(YEAR FROM date) = :year";
final var sql = "SELECT DISTINCT indicator FROM v_pra_dailyvalue WHERE EXTRACT(YEAR FROM date) = :year";
final List<Long> ids = super.findAllBySQL(sql, Map.of("year", year)).stream() //
.map(i -> Long.valueOf((int) i)).toList();
final var jpql = "SELECT i FROM Indicator AS i JOIN i.period WHERE i.id IN (:ids)";
Loading