"Fossies" - the Fresh Open Source Software Archive

Member "grails-core-5.2.4/grails-docs/src/test/resources/docs/ref/Domain Classes/where.html" (14 Sep 2022, 61133 Bytes) of package /linux/www/grails-core-5.2.4.tar.gz:


Caution: In this restricted "Fossies" environment the current HTML page may not be correctly presentated and may have some non-functional links. You can here alternatively try to browse the pure source code or just view or download the uninterpreted raw source code. If the rendering is insufficient you may try to find and view the page on the grails-core-5.2.4.tar.gz project site itself.

(Quick Reference)

where

Purpose

Defines a new grails.gorm.DetachedCriteria instance.

Examples

Basic query:

def query = Person.where {
   firstName == "Bart"
}
Person bart = query.find()

Conjunctions/Disjunctions:

def query = Person.where {
    (lastName != "Simpson" && firstName != "Fred") || (firstName == "Bart" && age > 9)
}
def results = query.list(sort:"firstName")

Property comparison:

def query = Person.where {
   firstName == lastName
}

Querying Associations:

def query = Pet.where {
    owner.firstName == "Joe" || owner.firstName == "Fred"
}

Subqueries:

final query = Person.where {
  age > avg(age)
}

Description

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.