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

0 vote378 views2 answers
Pagination in grails
Groovy
0 vote349 views1 answer
Groovy date + 1 day
Groovy
0 vote335 views1 answer
Relational in grails
Groovy
0 vote374 views1 answer
Groovy to string
Groovy
0 vote316 views1 answer
Marshaller in grails
Groovy
0 vote310 views1 answer
Copy files from an ubuntu server to remote server through ssh remote with cronjobs
Groovy
1 vote301 views1 answer
Groovy split string
Groovy
1 vote317 views2 answers
New date groovy
Groovy
0 vote329 views1 answer
Projections in grails
Groovy
0 vote423 views1 answer
How to copy folders from one server to another in ubuntu using regular intervals automatically
Groovy