Pull Request #4401
Add case history search by date range
Adds a /api/cases/search endpoint that queries the cases table with a native SQL BETWEEN filter on filed_at.
Client request
repository/CaseRepository.java+11 additions
1
+ @Repository
2
+ public interface CaseRepository extends JpaRepository<Case, Long> {
3
+
4
+ @Query(value = "SELECT * FROM cases WHERE " +
5
+ "filed_at BETWEEN :start AND :end " +
6
+ "ORDER BY filed_at DESC",
7
+ nativeQuery = true)
8
+ List<Case> findByFiledAtBetween(
9
+ @Param("start") LocalDate start,
10
+ @Param("end") LocalDate end);
11
+ }
Review comments · repository/CaseRepository.java