detachedCriteria.add(Restrictions.sqlRestriction("exists (select 'X' from workflowlog wlog where this_.id=wlog.workflowid and wlog.logtype in('402881e50c5b4646010c5b5afd17000b','402881e50c5b4646010c5b5afd17000a') and wlog.operator='" + hisoperator + "') or exists (select 'X' from workflowlogfinished wlogf where this_.id=wlogf.workflowid and wlogf.logtype in('402881e50c5b4646010c5b5afd17000b','402881e50c5b4646010c5b5afd17000a','402881e50c5b4646010c5b5afd170008') and wlogf.operator='" + hisoperator + "')"));
项目中exists的一点用法
最新推荐文章于 2021-01-27 17:19:53 发布