def query = Person.whereAny {
firstName == "Bart"
firstName == "Lisa"
}
Person bart = query.find()
where
Purpose
Defines a new grails.gorm.DetachedCriteria instance that uses a disjunction (logical OR).
Examples
Basic query:
Description
The where method defaults to a conjunction (logical AND) for the created query. The whereAny compliments the where method by allowing the creation of DetachedCriteria using a disjunction (logical OR).
The where method is a powerful new type-safe querying option introduced in Grails 2.0. For more information on using the where method see the dedicated section on Where Queries and Detached Criteria in the user guide.