create criteria in grails code example
Example 1: criteria in grails
def criteria = Person.createCriteria()
def result = criteria.list (max:10, offset:0) {
eq ('firstName', 'John')
}
Example 2: criteria in grails
def criteria = Person.createCriteria()
def result = criteria.list {
if (firstNameToSearch != null) {
eq('firstName', firstNameToSearch)
}
if (lastNameToSearch != null) {
eq('lastName', lastNameToSearch)
}
}
Example 3: criteria in grails
def criteria = Person.createCriteria()
def result = criteria.list {
or {
and {
eq('lastName', 'Doe')
gt('age', 15)
}
and {
eq('lastName', 'Smith')
gt('age', 18)
}
}
}