Spring Boot, Sorting, Searching, Filtering, Pagination.
LIKE :lookupText OR c.email LIKE :lookupText: This part is checking if the lookupText parameter is either null or matches the project name, description, contributor's name, mobile, or email. 👉 AND ((:startDate IS NULL AND :endDate IS NULL) OR (p.startDate <= :endDate AND p.endDate >= :startDate)):