HQL CASE语句用法

发布于 2024-12-07 01:00:15 字数 450 浏览 0 评论 0原文

我正在使用 HQL 并有此查询，

<query name="rule.myRule.query.by.name">
    <![CDATA[
        FROM rule.myRule as cr
        WHERE cr.name LIKE :name
        AND cr.type = 'myType'
        CASE 
            WHEN COUNT(cr.childRules) > 0
        THEN 
            cr.childRules LIKE :name
    ]]>
</query>

我需要一些帮助才能使此查询正确。我想要的是只有当 cr.childRules > 0 的计数时才执行条件 cr.childeRule LIKE :name 。

我哪里错了？

原文

I'm using HQL and have this query

<query name="rule.myRule.query.by.name">
    <![CDATA[
        FROM rule.myRule as cr
        WHERE cr.name LIKE :name
        AND cr.type = 'myType'
        CASE 
            WHEN COUNT(cr.childRules) > 0
        THEN 
            cr.childRules LIKE :name
    ]]>
</query>

I need some help making this query correct. What I want is to have the condition cr.childeRule LIKE :name execute only when the count of cr.childRules >0 .

Where am I wrong ?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

入画浅相思 2024-12-14 01:00:15

FROM rule.myRule as cr
left join cr.childRules childRule
WHERE cr.name LIKE :name
AND cr.type = 'myType'
and childRule.id is null or childRule.name = :name

应该做你想做的事。

FROM rule.myRule as cr
left join cr.childRules childRule
WHERE cr.name LIKE :name
AND cr.type = 'myType'
and childRule.id is null or childRule.name = :name

should do what you want.

回复收藏 0 原文

~没有更多了~