Limit result to 1

Question

I have this Spring JPA repository:

@Repository
public interface MerchantUserRepository extends JpaRepository<Users, Integer> {

    Optional<Users> findByIdAndTypeIn(Integer id, String... types);
}

Is there some way to limit the returned number of rows to 1?

Try this one `Optional findTop1ByIdAndTypeIn(Integer id,List types)` — Sana, Jul 02 '19 at 09:44
The method return a single object not a list. What exactly needs to be limited. — seenukarthi, Jul 02 '19 at 09:45
try `Optional findTop1ByIdAndTypeIn(Integer id, Collection types)` — dasunse, Nov 27 '19 at 10:42

score 0 · Answer 1 · answered Jul 02 '19 at 09:43

0

You add a Pageable param to your query:

Optional<Users> findByIdAndTypeIn(Integer id, String... types, Pageable page);

For one result you create it like:

Pageable firstRow = PageRequest.of(0, 1);

You may consider adding a Sort object also for your query in that case

answered Jul 02 '19 at 09:43

Maciej Kowalski

25,605
12
54
63

3

I don't see anything wrong in this post.. why is it down voted.(To the Person who Down Voted) – Avi Jul 02 '19 at 09:45
One additional question: can I use specification with above example? – Peter Penzov Jul 09 '19 at 12:02

Limit result to 1

1 Answers1