Can Spring Data REST’s QueryDSL integration be used to perform more complex queries?

by

I think you should be able to get this to work using the following customization:

bindings.bind(user.dateOfBirth).all((path, value) -> {

  Iterator<? extends LocalDate> it = value.iterator();
  return path.between(it.next(), it.next());
});

The key here is to use ?dateOfBirth=…&dateOfBirth= (use the property twice) and the ….all(…) binding which will give you access to all values provided.

Make sure you add the @DateTimeFormat annotation to the dateOfBirth-property of User so that Spring is able to convert the incoming Strings into LocalDate instances correctly.

The lambda currently gets a Collection<? extends T> which makes untangling the individual elements a bit more pain that it needs to be, but I think we can change this in a future release to rather expose a List.

More Related Contents:

  1. Dynamic spring data jpa repository query with arbitrary AND clauses
  2. Spring Data and Native Query with pagination
  3. Disable all Database related auto configuration in Spring Boot
  4. Spring data JPA query with parameter properties
  5. How to test Spring’s declarative caching support on Spring Data repositories?
  6. Spring Data optional parameter in query method
  7. Spring Data: “delete by” is supported?
  8. How to use OrderBy with findAll in Spring Data
  9. Can I make a custom controller mirror the formatting of Spring-Data-Rest / Spring-Hateoas generated classes?
  10. How to Log HttpRequest and HttpResponse in a file?
  11. Can’t Autowire @Repository annotated interface in Spring Boot
  12. Spring Boot Data JPA – Modifying update query – Refresh persistence context
  13. With Spring Data REST, why is the @Version property becoming an ETag and not included in the representation?
  14. Why is an excerpt projection not applied automatically for a Spring Data REST item resource?
  15. Spring Boot – Loading Initial Data
  16. Spring Data JPA map the native query result to Non-Entity POJO
  17. Using generics in Spring Data JPA repositories
  18. POSTing a @OneToMany sub-resource association in Spring Data REST
  19. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  20. How to use Spring managed Hibernate interceptors in Spring Boot?
  21. Handling soft-deletes with Spring JPA
  22. Spring-Data FETCH JOIN with Paging is not working
  23. Why use returned instance after save() on Spring Data JPA Repository?
  24. No property found for type… custom Spring Data repository
  25. How to use @Transactional with Spring Data?
  26. Spring @Transactional with a transaction across multiple data sources
  27. Spring Data JPA: Query by Example?
  28. Configure Multiple MongoDB repositories with Spring Data Mongo
  29. Pagination in Spring Data JPA (limit and offset)
  30. Best way of handling entities inheritance in Spring Data JPA

Leave a Comment