class Book {
String title
Date releaseDate
String author
static constraints = {
releaseDate nullable: true
}
}findAllWhere
Purpose
Uses named arguments corresponding to property names of the domain class to execute a query returning all matching results.
Examples
Given the domain class:
You can query in the form:
def books = Book.findAllWhere(author: "Stephen King", title: "The Stand")
def unreleasedBooks = Book.findAllWhere(releaseDate: null)Description
findAllWhere returns all matching instances. A null value in the argument map matches rows where that property is null.
Only domain class property names may be used as keys in the argument map. Invalid property names are rejected instead of being interpolated into the generated query.
Parameters:
-
queryParams- A Map of key/value pairs to be used in the query -
args- Optional query arguments such asmax,offset,cache,readOnly,fetchSize,timeout,flushMode, andlock