SpringData:查询注释中是否可以有子查询?

2022-01-18 00:00:00 java jpql spring-data

我想知道是否可以在@Query 注释中包含子查询(org.springframework.data.jpa.repository.Query;)

I would like to know if it is possible to have subquery in a @Query annotation (org.springframework.data.jpa.repository.Query;)

我在第一个子查询括号中收到 QuerySyntaxException.

I am getting a QuerySyntaxException on the first subquery parentesis.

这是我的查询

@Query(value="select c1 from ComplaintModel c1, "
+ "(select c2.id, min(cb.termDate) minDate from ComplaintModel c2 "
+ "join c2.complaintBullets cb join cb.status s where s.code = ?1 "
+ "group by c2.id) tmp where c1.id = tmp.id order by tmp.minDate")

谢谢！

推荐答案

不，JPQL查询的select子句中不能有子查询.

No, it is not possible to have subquery in the select clause in JPQL query.

JPQL 支持 WHERE 和 HAVING 子句中的子查询.它可以(至少)是 ANY、SOME、ALL、IN、EXIST 表达式的一部分，当然也可以使用普通的条件表达式:

JPQL supports subqueries in WHERE and HAVING clauses. It can be (at least) part of ANY, SOME, ALL, IN, EXIST expressions, and of course it can be used normal conditional expressions:

SELECT a
FROM A a
WHERE a.val = (SELECT b.someval 
               FROM B b 
               WHERE b.someotherval=3)

相关文章