Criteria in grails

def criteria = Person.createCriteria()
def result = criteria.list (max:10, offset:0) {
    eq ('firstName', 'John')
}

Criteria in grails

def criteria = Person.createCriteria()
def result = criteria.list {
    if (firstNameToSearch != null) {
        eq('firstName', firstNameToSearch)
    }
    if (lastNameToSearch != null) {
        eq('lastName', lastNameToSearch)
    }
}

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)
        }
    }
}

Similar codes

1 vote447 views1 answer
Get date now groovy
Groovy
0 vote414 views1 answer
ValueError: Cannot assign id to field when saving form
Groovy
1 vote417 views2 answers
Groovy list for loop
Groovy
0 vote439 views1 answer
Jsr223 postprocessor prev success
Groovy
1 vote428 views1 answer
For loop groovy
Groovy
0 vote414 views1 answer
Gorm in grails
Groovy
1 vote297 views1 answer
Groovy split string
Groovy
0 vote446 views2 answers
Pagination in grails
Groovy
0 vote421 views1 answer
Uncaught TypeError: s(...).tooltip is not a function
Groovy
0 vote411 views1 answer
Uwsgi command for defectdojo
Groovy