Question

where 条件后面可以跟 ()吗，里头写传过来的值，比如（or.id=''）

def hql = """
select CM.CustomerName as Cname
from CustomerMaster CM
inner join ContractMaster CME on CM.ID = CME.BusinessId
inner join ContractDetail CD on CME.ID = CD.ContractId
where ${customernameCondition} and CME.ContractType = '销售合同'
group by CM.CustomerName
"""
def salelist = []
println("-----------------------------------------"+hql)
def resulty = sql.rows(hql)

Answer 1

一般Where后面跟be动词.

追答

就是is are am

例：Where is the school near here?这里附近的学校在哪里？