Case Where Clause of JPQL is not Working as Expected

Mastering Pageable Requests with JPA and Spring Data JPA: Best Practices for Efficient Pagination