How can I pass a specification to a custom query on repository interface of spring data?

Question

In repository interface which extends JpaRepository, if we have our custom query e.g "getAllCustomersWhoAreOlderThan", how can we pass custom specification to this method?

Possible duplicate of [Can I combine a @Query definition and Specifications on one Spring Data JPA repository method?](https://stackoverflow.com/questions/26379522/can-i-combine-a-query-definition-and-specifications-on-one-spring-data-jpa-repo) — ValerioMC, Mar 21 '19 at 11:31
I didn't get any resolution from this thread. So I asked the question — AJ Winchester, Mar 22 '19 at 12:48

score 0 · Answer 1 · answered Jul 13 '19 at 09:55

0

you can't pass Specifications in mix @Query (or query-methods). the following queries using Specifications:

count(Specification spec)
List findAll(Specification spec)
Page findAll(Specification spec, Pageable pageable)
List findAll(Specification spec, Sort sort)
T findOne(Specification spec)

answered Jul 13 '19 at 09:55

zohreh

913
1
7
9

1

These are the methods provided in repository. Can we use specifications in custom queries just like we use pageable or sort? – AJ Winchester Jul 14 '19 at 10:17
yes of course, we can use Pageable and Sort in custom queries – zohreh Jul 14 '19 at 11:43
That's just an example. Can we use SPECIFICATIONS, LIKE we use paging and sorting – AJ Winchester Jul 15 '19 at 15:10
you can use specification just in general queries (ex: findAll() ) – zohreh Jul 16 '19 at 06:24

How can I pass a specification to a custom query on repository interface of spring data?

1 Answers1