Spring Boot, Sorting, Searching, Filtering, Pagination.
:lookupText " + "OR c.name LIKE :lookupText " + "OR c.mobile LIKE :lookupText " + "OR c.email LIKE :lookupText " + "AND ((:startDate IS NULL AND :endDate IS NULL) OR " + "(p.startDate <= :endDate AND p.endDate >= :startDate))") Page<Project> search(String lookupText, Date startDate, Date endDate,