Grails2.4发布

Grails2.4发布

新特性之一：where条件 子查询

def results = Person.where {
    firstName in where { age < 18 }.firstName
}.list()

def results = Person.withCriteria {
    notIn "firstName", Person.where { age < 18 }.firstName
}

def results = Person.where {
    age > where { age > 18 }.avg('age')
}

def employees = Employee.where {
    region.continent in ['APAC', "EMEA"]
}.id()
def results = Sale.where {
    employee in employees && total > 100000
}.employee.list()

def query = Employee.where {
    def em1 = Employee
    exists Sale.where {
        def s1 = Sale
        def em2 = employee
        return em2.id == em1.id
    }.id()
}
def results = query.list()