Query by Example Spring Data

Question

I have domain object Person with date fields:

public class Person {
@Id
private Long id;
private Date date

Build example like this:

Person person = new Person();
person.setSomeOtherFields("some fields");
Example<Person> example = Example.of(person);

How i can create example query with date range (search entity contains date greater or equal from some date and less or equal some another date)?

Eluvium

Answer 1

The Spring Data JPA query-by-example technique uses Examples and ExampleMatchers to convert entity instances into the underlying query. The current official documentation clarifies that only exact matching is available for non-string attributes. Since your requirement involves a java.util.Date field, you can only have exact matching with the query-by-example technique.

You could write your own ExampleMatcher that returns query clauses according to your needs.

Biysk