java - Filter associated entity on one query with hibernate and jpa? - Stack Overflow

admin管理员组

文章数量:1023867

I have question how to filter associated entity for example I have entity A

public class A {
 private Long id;
 @OneToMany
 private List<B> bList;
}

and entity B:

public class B {
 private Long id;
 private Boolean isActive;
 @ManyToOne
 private A a;
}

And for example I want to get List of A entities with filtered fetched B entities with isActive = true. But the problem is, that I want to do it in one query without foreach loop and searching separately B entities. I heared about @FilterJoinTable but this invoke another query to search B entity even if B entity is fetched eagerly. Also I try criteria api with listJoin an use .on() function but this doesn't work. So maybe there is no solution to get A entity with filtered B entity in one query and I should use only stream filter?

I have question how to filter associated entity for example I have entity A

public class A {
 private Long id;
 @OneToMany
 private List<B> bList;
}

and entity B:

public class B {
 private Long id;
 private Boolean isActive;
 @ManyToOne
 private A a;
}

And for example I want to get List of A entities with filtered fetched B entities with isActive = true. But the problem is, that I want to do it in one query without foreach loop and searching separately B entities. I heared about @FilterJoinTable but this invoke another query to search B entity even if B entity is fetched eagerly. Also I try criteria api with listJoin an use .on() function but this doesn't work. So maybe there is no solution to get A entity with filtered B entity in one query and I should use only stream filter?

• java
• hibernate
• jpa
• criteria-api

Share Improve this question Follow edited Nov 18, 2024 at 17:40 Pioter asked Nov 18, 2024 at 17:25 PioterPioter 1333 bronze badges 1

• from A join fetch bList b where b.isActive: translete this query to criteria is not so difficult (is just a join-fetch with a clause) – Luca Basso Ricci Commented Nov 19, 2024 at 6:55

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

You can add @SQLRestriction("isActive=true") to List<B> bList.

Note that you can't turn it off.

I have question how to filter associated entity for example I have entity A

public class A {
 private Long id;
 @OneToMany
 private List<B> bList;
}

and entity B:

public class B {
 private Long id;
 private Boolean isActive;
 @ManyToOne
 private A a;
}

And for example I want to get List of A entities with filtered fetched B entities with isActive = true. But the problem is, that I want to do it in one query without foreach loop and searching separately B entities. I heared about @FilterJoinTable but this invoke another query to search B entity even if B entity is fetched eagerly. Also I try criteria api with listJoin an use .on() function but this doesn't work. So maybe there is no solution to get A entity with filtered B entity in one query and I should use only stream filter?

I have question how to filter associated entity for example I have entity A

public class A {
 private Long id;
 @OneToMany
 private List<B> bList;
}

and entity B:

public class B {
 private Long id;
 private Boolean isActive;
 @ManyToOne
 private A a;
}

And for example I want to get List of A entities with filtered fetched B entities with isActive = true. But the problem is, that I want to do it in one query without foreach loop and searching separately B entities. I heared about @FilterJoinTable but this invoke another query to search B entity even if B entity is fetched eagerly. Also I try criteria api with listJoin an use .on() function but this doesn't work. So maybe there is no solution to get A entity with filtered B entity in one query and I should use only stream filter?

• java
• hibernate
• jpa
• criteria-api

Share Improve this question Follow edited Nov 18, 2024 at 17:40 Pioter asked Nov 18, 2024 at 17:25 PioterPioter 1333 bronze badges 1

• from A join fetch bList b where b.isActive: translete this query to criteria is not so difficult (is just a join-fetch with a clause) – Luca Basso Ricci Commented Nov 19, 2024 at 6:55

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

You can add @SQLRestriction("isActive=true") to List<B> bList.

Note that you can't turn it off.

本文标签： javaFilter associated entity on one query with hibernate and jpaStack Overflow