Find objects by multiple values in nested List object Hibernate, Jpa

Question

I have Student entity. Students have list of subjects in ManyToMany relationship. Something like this:

@Entity
@Table(name = "students")
public class Student {
@ManyToMany(cascade = CascadeType.DETACH)
    @JoinTable(name = "student_subject", joinColumns = @JoinColumn(name = "student_id"), inverseJoinColumns = @JoinColumn(name = "subject_id"))
    private List<Subject> subjects ;
}

I want to get all students that contain any of the requested subjects in my repository, something like this:

List<Student> findBySubjects(List<Subject> requestedSubjects)

Is this the right way to go? If not, is it even possible to do it like this? Thanks!

Welcome to SO. Please have a look here to learn how to improve your questions (formatting, proofreading, providing code etc.): stackoverflow.com/help/how-to-ask — petezurich
– petezurich, Commented Apr 20, 2018 at 19:59

Bogdan Lukiyanchuk · Accepted Answer · 2018-04-20 20:13:11Z

1

You can use @Query annotation.

@Query("SELECT student FROM Student student INNER JOIN student.subjects subject WHERE subject IN (:subjects)")
List<Student> findBySubjects(@Param("subjects") List<Subject> requestedSubjects)

answered Apr 20, 2018 at 20:13

Bogdan Lukiyanchuk

7774 silver badges19 bronze badges

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

2 Comments

vibetribe93 Over a year ago

Hello, it is implemented. Will inform when I test it out. Thanks!

vibetribe93 Over a year ago

Works like a charm! Went into depth a little bit with custom queries, have better knowledge of it now thanks to you! Mustache gracias :)

Collectives™ on Stack Overflow

Find objects by multiple values in nested List object Hibernate, Jpa

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related