ElasticSearchRepository null query does not work

Question

Spring data elastic search repository doesn't work as expexcted. For the method below, it gives the following exception.

org.springframework.dao.InvalidDataAccessApiUsageException: Illegal criteria found 'IS_NULL (0): [IsNull, Null]'.

public interface CustomerRepository extends ElasticsearchRepository<Customer, Long> {

   List<Customer> findByFirstNameIsNull();

}

Anil · Accepted Answer · 2019-01-25 09:48:17Z

1

You can write something like below in the repository:

Page<Customer> findByFirstName(String firstName, Pageable pageable);

And calling it with

findByFirstName(null, PageRequest.of(0,100));

Will give you the first 100 results that have null values in their first names.

answered Jan 25, 2019 at 9:48

Anil

5734 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1