How to add restriction to range between two dates on query by example in Spring Data

Question

I have one class with two dates and my search is dynamic, Hibernate provides Query By Example (QBE), but now use QBE of Spring Data. The problem is when created a QBE but the documentation restrict the ExampleMatcher for String types, i need create a ExampleMatcher for search all entities between in this dates.

How implement this using query by example?.

My alternatives for now is:

Create a hibernate dao and use QBE and criteria of hibernate (Bye JPA :'( )
Explore this http://spring.io/blog/2011/04/26/advanced-spring-data-jpa-specifications-and-querydsl/ (really ugly code)

Example properties for class:

  private int id;
  private String property1;
  private String property2;
  private Date dateFirst;
  private Date dateSecond;

score 9 · Accepted Answer · answered Dec 09 '16 at 08:53

9

The short answer is, you don't. Query by example is considered exactly what its name suggests: you give an example and the query is built on a match of the given fields. That's also documented in the "Limitations" section of the reference documentation you linked to.

For more advanced use cases and predicate definitions, have a look at the Querydsl support.

answered Dec 09 '16 at 08:53

Oliver Drotbohm

80,157
18
225
211

i prefer make a dao and use hibernate criteria for this purpose for now , i need study this case and how to combine with hibernate-search, thanks , great project – Israel Perales Dec 28 '16 at 22:29

How to add restriction to range between two dates on query by example in Spring Data

1 Answers1

Linked