Pull Request #4421
Add case file search by date range
Adds GET /api/cases/search with start and end date parameters. Filters the cases table by filed_at and returns matching records.
Ready to merge
repository/CaseRepository.java+19 additions
Viewed1
@Repository
2
public interface CaseRepository extends JpaRepository<Case, Long> {
3
4
List<Case> findByOwnerId(Long ownerId);
5
6
+ @Query(value = """
7
+ SELECT * FROM cases
8
+ WHERE filed_at BETWEEN :start AND :end
9
+ ORDER BY filed_at DESC""",
10
+ nativeQuery = true)
11
+ List<Case> findByFiledAtBetween(
12
+ @Param("start") LocalDate start,
13
+ @Param("end") LocalDate end);
14
+
15
+ }
DL
deepak_lead
Approved review
Query looks right to me. Tested it locally — fast results. LGTM.