How to sort By Name and status Active for JPA repository query?

Question

I am developing Spring Boot + Spring Data JPA + Postgres + Lombok example. In this example, I want to fetch all student firstName is ASC order and whose status in Active.

I developed below query, which works fine, but I dont see a way to also use status=Active here in JpaRepository query.

NOTE: In my case, status field is Enum in Java.

Is there any way if we can do the same ? I know I can fetch all students and then using streams can easily filter, but using JpaRepository query, is there any way?

List<Student> students = studentRepository.findAll(new Sort(Sort.Direction.ASC, "studentName"));

you can do this findAllByStatusOrderByStudentNameAsc – Med Elgarnaoui Jul 11 '19 at 09:03 — Med Elgarnaoui, Jul 11 '19 at 09:03

riorio · Accepted Answer · 2019-07-11T09:11:58.830

3

In your StudentRepository interface, that extends Repository / JpaRepository you can add a method signature like that:

public interface StudentRepository extends ....{
  List<Student> findAllByStatusOrderByStudentNameAsc(String status);
}

edited Jul 11 '19 at 09:11

answered Jul 11 '19 at 09:00

riorio

5,015
5
29
70

Isn't this the same answer posted by me. – Johna Jul 11 '19 at 09:02
It seems you were actually 1 minute later. – Saffie Jul 11 '19 at 09:05
@Johna I wrote my answer at the same time as you and submitted if a few seconds after you. I'll give your answer a vote up. – riorio Jul 11 '19 at 09:06
@riorio I understood it friend. No competition here, if he found the answer to his problem, that's it. – Johna Jul 11 '19 at 09:10

score 1 · Answer 2 · answered Jul 11 '19 at 08:59

1

Just put the following method signature in your repository and call it where you need with argument 'Active'.

List<Student> findAllByStatusOrderByStudentNameAsc(String status);

answered Jul 11 '19 at 08:59

Johna

1,416
2
12
24

How to sort By Name and status Active for JPA repository query?

2 Answers2