Method Detail

• public Criteria allEq(java.util.Map<java.lang.String, java.lang.Object> propertyValues)

  Apply an "equals" constraint to each property in the key set of a Map

  Parameters:

  propertyValues - a map from property names to values

  Returns:

  Criterion

  See Also:

  org.grails.datastore.mapping.query.Query.Conjunction

• public Criteria and(@groovy.lang.DelegatesTo(Criteria.class)
  groovy.lang.Closure callable)

  Creates a logical conjunction

  Parameters:

  callable - The closure

  Returns:

  This criteria

• public Criteria between(java.lang.String propertyName, java.lang.Object start, java.lang.Object finish)

  Restricts the results by the given property value range (inclusive)

  Parameters:

  propertyName - The property name

  start - The start of the range

  finish - The end of the range

  Returns:

  The criteria

• public Criteria cache(boolean shouldCache)

  Configures the second-level cache with the default usage of 'read-write' and the default include of 'all' if the passed argument is true { cache true }

  Parameters:

  shouldCache - True if the default cache configuration should be applied

  Returns:

  This Criteria instance

• public Criteria eq(java.lang.String propertyName, java.lang.Object propertyValue)

  Creates an "equals" Criterion based on the specified property name and value

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  The criteria

• public Criteria eqAll(java.lang.String propertyName, groovy.lang.Closure<?> propertyValue)

  Creates a subquery criterion that ensures the given property is equals to all the given returned values

  Parameters:

  propertyName - The property name

  propertyValue - A closure that is converted to a QueryableCriteria

  Returns:

  This criterion instance

• public Criteria eqAll(java.lang.String propertyName, QueryableCriteria propertyValue)

  Creates a subquery criterion that ensures the given property is equal to all the given returned values

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  This Criteria instance

• public Criteria eqProperty(java.lang.String propertyName, java.lang.String otherPropertyName)

  Constrains a property to be equal to a specified other property

  Parameters:

  propertyName - The property

  otherPropertyName - The other property

  Returns:

  This criteria

• public Criteria exists(QueryableCriteria<?> subquery)

  Executes an exists subquery

  Parameters:

  subquery - The subquery

  Returns:

  this criteria

• public Criteria ge(java.lang.String property, java.lang.Object value)

  Used to restrict a value to be greater than or equal to the given value

  Parameters:

  property - The property

  value - The value

  Returns:

  The Criterion instance

• public Criteria geAll(java.lang.String propertyName, groovy.lang.Closure<?> propertyValue)

  Creates a subquery criterion that ensures the given property is greater than or equals to all the given returned values

  Parameters:

  propertyName - The property name

  propertyValue - A closure that is converted to a QueryableCriteria

  Returns:

  This criterion instance

• public Criteria geAll(java.lang.String propertyName, QueryableCriteria propertyValue)

  Creates a subquery criterion that ensures the given property is greater than all the given returned values

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  This Criteria instance

• public Criteria geProperty(java.lang.String propertyName, java.lang.String otherPropertyName)

  Constrains a property to be greater than or equal to a specified other property

  Parameters:

  propertyName - The property

  otherPropertyName - The other property

  Returns:

  This criteria

• public Criteria geSome(java.lang.String propertyName, QueryableCriteria propertyValue)

  Creates a subquery criterion that ensures the given property is greater than or equal to some of the given values

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  This Criteria instance

• public Criteria geSome(java.lang.String propertyName, groovy.lang.Closure<?> propertyValue)

  Creates a subquery criterion that ensures the given property is greater than or equal to some of the given values

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  This Criteria instance

• public Criteria gt(java.lang.String property, java.lang.Object value)

  Used to restrict a value to be greater than or equal to the given value

  Parameters:

  property - The property

  value - The value

  Returns:

  The Criterion instance

• public Criteria gtAll(java.lang.String propertyName, groovy.lang.Closure<?> propertyValue)

  Creates a subquery criterion that ensures the given property is greater than all the given returned values

  Parameters:

  propertyName - The property name

  propertyValue - A closure that is converted to a QueryableCriteria

  Returns:

  This criterion instance

• public Criteria gtAll(java.lang.String propertyName, QueryableCriteria propertyValue)

  Creates a subquery criterion that ensures the given property is greater than all the given returned values

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  This Criteria instance

• public Criteria gtProperty(java.lang.String propertyName, java.lang.String otherPropertyName)

  Constrains a property to be greater than a specified other property

  Parameters:

  propertyName - The property

  otherPropertyName - The other property

  Returns:

  This criteria

• public Criteria gtSome(java.lang.String propertyName, QueryableCriteria propertyValue)

  Creates a subquery criterion that ensures the given property is greater than some of the given values

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  This Criteria instance

• public Criteria gtSome(java.lang.String propertyName, groovy.lang.Closure<?> propertyValue)

  Creates a subquery criterion that ensures the given property is greater than some of the given values

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  This Criteria instance

• public Criteria gte(java.lang.String property, java.lang.Object value)

  Used to restrict a value to be greater than or equal to the given value

  Parameters:

  property - The property

  value - The value

  Returns:

  The Criterion instance

• public Criteria idEq(java.lang.Object propertyValue)

  Creates an "equals" Criterion based on the specified property name and value

  Parameters:

  propertyValue - The property value

  Returns:

  The criteria

• public Criteria idEquals(java.lang.Object value)

  Creates a criterion that restricts the id to the given value

  Parameters:

  value - The value

  Returns:

  The criteria

• public Criteria ilike(java.lang.String propertyName, java.lang.Object propertyValue)

  Creates an ilike Criterion based on the specified property name and value. Unlike a like condition, ilike is case insensitive

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  The criteria

• public Criteria in(java.lang.String propertyName, java.util.Collection values)

  Creates an "in" Criterion based on the specified property name and list of values

  Parameters:

  propertyName - The property name

  values - The values

  Returns:

  The criteria

• public Criteria in(java.lang.String propertyName, QueryableCriteria<?> subquery)

  Creates an "in" Criterion using a subquery

  Parameters:

  propertyName - The property name

  subquery - The subquery

  Returns:

  The criteria

• public Criteria in(java.lang.String propertyName, groovy.lang.Closure<?> subquery)

  Creates an "in" Criterion using a subquery

  Parameters:

  propertyName - The property name

  subquery - The subquery

  Returns:

  The criteria

• public Criteria in(java.lang.String propertyName, java.lang.Object[] values)

  Creates an "in" Criterion based on the specified property name and list of values

  Parameters:

  propertyName - The property name

  values - The values

  Returns:

  The criteria

• public Criteria inList(java.lang.String propertyName, QueryableCriteria<?> subquery)

  Creates an "in" Criterion using a subquery

  Parameters:

  propertyName - The property name

  subquery - The subquery

  Returns:

  The criteria

• public Criteria inList(java.lang.String propertyName, groovy.lang.Closure<?> subquery)

  Creates an "in" Criterion using a subquery

  Parameters:

  propertyName - The property name

  subquery - The subquery

  Returns:

  The criteria

• public Criteria inList(java.lang.String propertyName, java.util.Collection values)

  Creates an "in" Criterion based on the specified property name and list of values

  Parameters:

  propertyName - The property name

  values - The values

  Returns:

  The criteria

• public Criteria inList(java.lang.String propertyName, java.lang.Object[] values)

  Creates an "in" Criterion based on the specified property name and list of values

  Parameters:

  propertyName - The property name

  values - The values

  Returns:

  The criteria

• public Criteria isEmpty(java.lang.String propertyName)

  Creates a criterion that asserts the given property is empty (such as a blank string)

  Parameters:

  propertyName - The property name

  Returns:

  The criteria

• public Criteria isNotEmpty(java.lang.String propertyName)

  Creates a criterion that asserts the given property is not empty

  Parameters:

  propertyName - The property name

  Returns:

  The criteria

• public Criteria isNotNull(java.lang.String propertyName)

  Creates a criterion that asserts the given property is not null

  Parameters:

  propertyName - The property name

  Returns:

  The criteria

• public Criteria isNull(java.lang.String propertyName)

  Creates a criterion that asserts the given property is null

  Parameters:

  propertyName - The property name

  Returns:

  The criteria

• public Criteria le(java.lang.String property, java.lang.Object value)

  Used to restrict a value to be less than or equal to the given value

  Parameters:

  property - The property

  value - The value

  Returns:

  The Criterion instance

• public Criteria leAll(java.lang.String propertyName, groovy.lang.Closure<?> propertyValue)

  Creates a subquery criterion that ensures the given property is less than or equal to all the given returned values

  Parameters:

  propertyName - The property name

  propertyValue - A closure that is converted to a QueryableCriteria

  Returns:

  This criterion instance

• public Criteria leAll(java.lang.String propertyName, QueryableCriteria propertyValue)

  Creates a subquery criterion that ensures the given property is less than all the given returned values

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  This Criteria instance

• public Criteria leProperty(java.lang.String propertyName, java.lang.String otherPropertyName)

  Constrains a property to be less than or equal to a specified other property

  Parameters:

  propertyName - The property

  otherPropertyName - The other property

  Returns:

  This criteria

• public Criteria leSome(java.lang.String propertyName, QueryableCriteria propertyValue)

  Creates a subquery criterion that ensures the given property is less than or equal to some of the given values

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  This Criteria instance

• public Criteria leSome(java.lang.String propertyName, groovy.lang.Closure<?> propertyValue)

  Creates a subquery criterion that ensures the given property is less than or equal to some of the given values

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  This Criteria instance

• public Criteria like(java.lang.String propertyName, java.lang.Object propertyValue)

  Creates a like Criterion based on the specified property name and value

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  The criteria

• public Criteria lt(java.lang.String property, java.lang.Object value)

  Used to restrict a value to be less than or equal to the given value

  Parameters:

  property - The property

  value - The value

  Returns:

  The Criterion instance

• public Criteria ltAll(java.lang.String propertyName, groovy.lang.Closure<?> propertyValue)

  Creates a subquery criterion that ensures the given property is less than all the given returned values

  Parameters:

  propertyName - The property name

  propertyValue - A closure that is converted to a QueryableCriteria

  Returns:

  This criterion instance

• public Criteria ltAll(java.lang.String propertyName, QueryableCriteria propertyValue)

  Creates a subquery criterion that ensures the given property is less than all the given returned values

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  This Criteria instance

• public Criteria ltProperty(java.lang.String propertyName, java.lang.String otherPropertyName)

  Constrains a property to be less than a specified other property

  Parameters:

  propertyName - The property

  otherPropertyName - The other property

  Returns:

  This criteria

• public Criteria ltSome(java.lang.String propertyName, QueryableCriteria propertyValue)

  Creates a subquery criterion that ensures the given property is less than some of the given values

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  This Criteria instance

• public Criteria ltSome(java.lang.String propertyName, groovy.lang.Closure<?> propertyValue)

  Creates a subquery criterion that ensures the given property is less than some of the given values

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  This Criteria instance

• public Criteria lte(java.lang.String property, java.lang.Object value)

  Used to restrict a value to be less than or equal to the given value

  Parameters:

  property - The property

  value - The value

  Returns:

  The Criterion instance

• public Criteria ne(java.lang.String propertyName, java.lang.Object propertyValue)

  Creates a "not equals" Criterion based on the specified property name and value

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  The criteria

• public Criteria neProperty(java.lang.String propertyName, java.lang.String otherPropertyName)

  Constrains a property to be not equal to a specified other property

  Parameters:

  propertyName - The property

  otherPropertyName - The other property

  Returns:

  This criteria

• public Criteria not(@groovy.lang.DelegatesTo(Criteria.class)
  groovy.lang.Closure callable)

  Creates a logical negation

  Parameters:

  callable - The closure

  Returns:

  This criteria

• public Criteria notExists(QueryableCriteria<?> subquery)

  Executes a not exists subquery

  Parameters:

  subquery - The subquery

  Returns:

  this criteria

• public Criteria notIn(java.lang.String propertyName, QueryableCriteria<?> subquery)

  Creates a negated "in" Criterion using a subquery

  Parameters:

  propertyName - The property name

  subquery - The subquery

  Returns:

  The criteria

• public Criteria notIn(java.lang.String propertyName, groovy.lang.Closure<?> subquery)

  Creates a negated "in" Criterion using a subquery

  Parameters:

  propertyName - The property name

  subquery - The subquery

  Returns:

  The criteria

• public Criteria or(@groovy.lang.DelegatesTo(Criteria.class)
  groovy.lang.Closure callable)

  Creates a logical disjunction

  Parameters:

  callable - The closure

  Returns:

  This criteria

• public Criteria order(java.lang.String propertyName)

  Orders by the specified property name (defaults to ascending)

  Parameters:

  propertyName - The property name to order by

  Returns:

  This criteria

• public Criteria order(Order o)

  Adds an order object

  Parameters:

  o - The order object

  Returns:

  The order object

• public Criteria order(java.lang.String propertyName, java.lang.String direction)

  Orders by the specified property name and direction

  Parameters:

  propertyName - The property name to order by

  direction - Either "asc" for ascending or "desc" for descending

  Returns:

  This criteria

• public Criteria readOnly(boolean readOnly)

  Configures the hibernate readOnly property to avoid checking for changes on the objects if the passed argument is true { readOnly true }

  Parameters:

  readOnly - True to disable dirty checking

  Returns:

  This Criteria instance

• public Criteria rlike(java.lang.String propertyName, java.lang.Object propertyValue)

  Creates an rlike Criterion based on the specified property name and value

  Parameters:

  propertyName - The property name

  propertyValue - The property value

  Returns:

  The criteria

• public Criteria sizeEq(java.lang.String propertyName, int size)

  Creates a Criterion that constrains a collection property by size

  Parameters:

  propertyName - The property name

  size - The size to constrain by

  Returns:

  This criteria

• public Criteria sizeGe(java.lang.String propertyName, int size)

  Creates a Criterion that constrains a collection property to be greater than or equal to the given size

  Parameters:

  propertyName - The property name

  size - The size to constrain by

  Returns:

  This criteria

• public Criteria sizeGt(java.lang.String propertyName, int size)

  Creates a Criterion that constrains a collection property to be greater than the given size

  Parameters:

  propertyName - The property name

  size - The size to constrain by

  Returns:

  This criteria

• public Criteria sizeLe(java.lang.String propertyName, int size)

  Creates a Criterion that constrains a collection property to be less than or equal to the given size

  Parameters:

  propertyName - The property name

  size - The size to constrain by

  Returns:

  This criteria

• public Criteria sizeLt(java.lang.String propertyName, int size)

  Creates a Criterion that constrains a collection property to be less than to the given size

  Parameters:

  propertyName - The property name

  size - The size to constrain by

  Returns:

  This criteria

• public Criteria sizeNe(java.lang.String propertyName, int size)

  Creates a Criterion that constrains a collection property to be not equal to the given size

  Parameters:

  propertyName - The property name

  size - The size to constrain by

  Returns:

  This criteria