Spring JPA ExampleMatcher compare date condition

Question

I'm using Spring JPA and get list of data by using Example Matcher. Source code below:

public Page<TranxLog> findAllByConditions(TranxReportFormModel formModel, Pageable page) {
        ExampleMatcher matcher = ExampleMatcher.matching()
                .withNullHandler(ExampleMatcher.NullHandler.IGNORE)
                .withStringMatcher(ExampleMatcher.StringMatcher.CONTAINING)
                .withIgnoreCase()
                .withIgnoreNullValues();
        Example<TranxLog> example = Example.of(formModel.getTranxLog(), matcher);
        return tranxlogRepository.findAll(example, page);
    }

Now, I have search page, which have formDate and toDate and it has to be compared with field DateTime in TranxLog. I tried to use .withMatcher() but cannot find a way to compare a date.

Any idea? Thanks.

score 12 · Answer 1 · answered May 13 '20 at 14:19

You can extends from JpaSpecificationExecutor too and get the Predicate with QueryByExamplePredicateBuilder from Example.

In your repository:

public interface TranxlogRepository extends JpaRepository<Tranxlog, Long>, JpaSpecificationExecutor<Tranxlog>{ 
}

In your serviceImp

public Specification<TranxLog> getSpecFromDatesAndExample(
  LocalDateTime from, LocalDateTime to, Example<TranxLog> example) {

    return (Specification<TranxLog>) (root, query, builder) -> {
         final List<Predicate> predicates = new ArrayList<>();

         if (from != null) {
            predicates.add(builder.greaterThan(root.get("dateField"), from));
         }
         if (to != null) {
            predicates.add(builder.lessThan(root.get("dateField"), to));
         }
         predicates.add(QueryByExamplePredicateBuilder.getPredicate(root, builder, example));

         return builder.and(predicates.toArray(new Predicate[predicates.size()]));
    }
};

In your serviceImp too:

public Page<TranxLog> findAllByConditions(TranxReportFormModel formModel, Pageable page) {
    ExampleMatcher matcher = ExampleMatcher.matching()
            .withNullHandler(ExampleMatcher.NullHandler.IGNORE)
            .withStringMatcher(ExampleMatcher.StringMatcher.CONTAINING)
            .withIgnoreCase()
            .withIgnoreNullValues();
    Example<TranxLog> example = Example.of(formModel.getTranxLog(), matcher);
    return tranxlogRepository.findAll(getSpecFromDatesAndExample(from, to, Example.of(formModel.getTranxLog(), matcher)), page);
}

Worked for me as expected. I wanted to filter from the records with a `from` date (in epoch time) provided in the API endpoint. Thanks! — Akhil, Jun 13 '22 at 14:43

score 3 · Answer 2 · answered Jan 18 '18 at 14:04

3

You can't do that with query-by-example. Probably the best is to construct a Specification

answered Jan 18 '18 at 14:04

Jens Schauder

77,657
34
181
348

it got deprecated. And how to combine both Example and Speicification? In date I want range, but in the primary key, I want to give full value. – Satish Patro Jan 03 '20 at 07:49
1

You can't combine query by example and `Specification` but nothing is keeping you to create a specification from an entity. Also `Specification` isn't deprecated, only `Specifications` is (note the s at the end). – Jens Schauder Jan 03 '20 at 08:34

Spring JPA ExampleMatcher compare date condition

2 Answers2

Linked