class Book {
String title
Date releaseDate
String author
static constraints = {
releaseDate nullable: true
}
}findWhere
Purpose
Uses named arguments corresponding to domain class property names to execute a query returning the first matching result.
Examples
Given the domain class:
You can query in the form:
def book = Book.findWhere(author: "Stephen King", title: "The Stand")
boolean isReleased = Book.findWhere(author: "Stephen King",
title: "The Stand",
releaseDate: null) != nullDescription
findWhere returns the first matching instance, or null when no instance matches. 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- AMapof key/value pairs to be used in the query -
args- Optional query arguments such asoffset,cache,readOnly,fetchSize,timeout,flushMode, andlock.findWherealways limits the query to one result.