HQL查询

1、
Company:
static hasMany = [
organizations:Organization,operators:Operator
]
Operator:
Company company //所属单位
"SELECT company.operators FROM Company company WHERE EXISTS(FROM company.operators opes where opes.id=2 )
"
2、
PM:
List auditor; //审批人
static hasMany = [partake:Partake,auditor:Operator]

"hql.append("and EXISTS(FROM Operator ope2 WHERE ope2.operatorName like '%"+query+"%' and ope2 in elements(pm.auditor)) ")"