Spring Data JPA apply sorting, pagination along with a where clause

Question

I am currently Using Spring JPA and utilizing the Sorting and Pagination as described here -

How to query data via Spring data JPA by sort and pageable both out of box？

Now my question is how do I apply a 'where' clause to this?

E.g.

where PRODUCT_NAME='abc';

Answer 1

Just create a query method in your repository interface for this.

Take a look in the docs, here.

Add a query method with paging and where clause.

Page<User> findByLastname(String lastname, Pageable pageable);

So you can find User by a property "lastname" and configure Paging settings.

Answer 2

The easiest way I could find is to use QueryDSL or Specifications. I prefer QueryDSL.