Restrictions (Grace Data

org.grails.datastore.mapping.query.Restrictions

```
public class Restrictions
extends Object
```
Factory for creating org.grails.datastore.mapping.query.Query.Criterion instances

Methods Summary

Methods
Type Params	Return Type	Name and description
	`public static Criterion`	`and(Criterion a, Criterion b)`
	`public static Between`	`between(String property, Object start, Object end)` Restricts the results by the given property value range
	`public static Equals`	`eq(String property, Object value)` Restricts the property to be equal to the given value
	`public static EqualsProperty`	`eqProperty(String propertyName, String otherPropertyName)` Constraints a property to be equal to a specified other property
	`public static GreaterThanEqualsProperty`	`geProperty(String propertyName, String otherPropertyName)` Constraints a property to be greater than or equal to a specified other property
	`public static GreaterThan`	`gt(String property, Object value)` Used to restrict a value to be greater than the given value
	`public static GreaterThanProperty`	`gtProperty(String propertyName, String otherPropertyName)` Constraints a property to be greater than a specified other property
	`public static GreaterThanEquals`	`gte(String property, Object value)` Used to restrict a value to be greater than or equal to the given value
	`public static IdEquals`	`idEq(Object value)` Restricts the property to be equal to the given value
	`public static ILike`	`ilike(String property, String expression)` Case insensitive like
	`public static In`	`in(String property, Collection<?> values)` Restricts the property to be in the list of given values
	`public static In`	`in(String property, QueryableCriteria subquery)` Restricts the property to be in the list of given values
	`public static IsEmpty`	`isEmpty(String property)` Used to restrict a value to be empty (such as a blank string or an empty collection)
	`public static IsNotEmpty`	`isNotEmpty(String property)` Used to restrict a value to be not empty (such as a non-blank string)
	`public static IsNotNull`	`isNotNull(String property)` Used to restrict a value to be null
	`public static IsNull`	`isNull(String property)` Used to restrict a value to be null
	`public static LessThanEqualsProperty`	`leProperty(String propertyName, String otherPropertyName)` Constraints a property to be less than or equal to a specified other property
	`public static Like`	`like(String property, String expression)` Restricts the property match the given String expressions.
	`public static LessThan`	`lt(String property, Object value)` Used to restrict a value to be less than the given value
	`public static LessThanProperty`	`ltProperty(String propertyName, String otherPropertyName)` Constraints a property to be less than a specified other property
	`public static LessThanEquals`	`lte(String property, Object value)` Used to restrict a value to be less than or equal to the given value
	`public static NotEquals`	`ne(String property, Object value)`
	`public static NotEqualsProperty`	`neProperty(String propertyName, String otherPropertyName)` Constraints a property to be not equal to a specified other property
	`public static NotIn`	`notIn(String property, QueryableCriteria subquery)` Restricts the property to be in the list of given values
	`public static Criterion`	`or(Criterion a, Criterion b)`
	`public static RLike`	`rlike(String property, String expression)` Restricts the property match the given regular expressions.
	`public static SizeEquals`	`sizeEq(String property, int size)` Used to restrict the size of a collection property
	`public static SizeGreaterThanEquals`	`sizeGe(String property, int size)` Used to restrict the size of a collection property to be greater than or equal to the given value
	`public static SizeGreaterThan`	`sizeGt(String property, int size)` Used to restrict the size of a collection property to be greater than the given value
	`public static SizeLessThanEquals`	`sizeLe(String property, int size)` Creates a Criterion that contrains a collection property to be less than or equal to the given size
	`public static SizeLessThan`	`sizeLt(String property, int size)` Creates a Criterion that contrains a collection property to be less than to the given size
	`public static SizeNotEquals`	`sizeNe(String property, int size)` Creates a Criterion that contrains a collection property to be not equal to the given size

Inherited Methods Summary

Inherited Methods
Methods inherited from class	Name
`class Object`	`equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

- Method Detail
  - public static Criterion and(Criterion a, Criterion b)
  - public static Between between(String property, Object start, Object end)
    
    Restricts the results by the given property value range
    Parameters:
    property - The name of the property
    start - The start of the range
    end - The end of the range
    Returns:
    The Between instance
  - public static Equals eq(String property, Object value)
    
    Restricts the property to be equal to the given value
    Parameters:
    property - The property
    value - The value
    Returns:
    An instance of Query.Equals
  - public static EqualsProperty eqProperty(String propertyName, String otherPropertyName)
    
    Constraints a property to be equal to a specified other property
    Parameters:
    propertyName - The property
    otherPropertyName - The other property
    Returns:
    The criterion instance
  - public static GreaterThanEqualsProperty geProperty(String propertyName, String otherPropertyName)
    
    Constraints a property to be greater than or equal to a specified other property
    Parameters:
    propertyName - The property
    otherPropertyName - The other property
    Returns:
    The criterion
  - public static GreaterThan gt(String property, Object value)
    
    Used to restrict a value to be greater than the given value
    Parameters:
    property - The property
    value - The value
    Returns:
    The GreaterThan instance
  - public static GreaterThanProperty gtProperty(String propertyName, String otherPropertyName)
    
    Constraints a property to be greater than a specified other property
    Parameters:
    propertyName - The property
    otherPropertyName - The other property
    Returns:
    The criterion
  - public static GreaterThanEquals gte(String property, 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 LessThan instance
  - public static IdEquals idEq(Object value)
    
    Restricts the property to be equal to the given value
    Parameters:
    value - The value
    Returns:
    An instance of Query.Equals
  - public static ILike ilike(String property, String expression)
    
    Case insensitive like
    Parameters:
    property - The property
    expression - The expression
    Returns:
    An ILike expression
  - public static In in(String property, Collection<?> values)
    
    Restricts the property to be in the list of given values
    Parameters:
    property - The property
    values - The values
    Returns:
    An instance of Query.In
  - public static In in(String property, QueryableCriteria subquery)
    
    Restricts the property to be in the list of given values
    Parameters:
    property - The property
    subquery - The subquery
    Returns:
    An instance of Query.In
  - public static IsEmpty isEmpty(String property)
    
    Used to restrict a value to be empty (such as a blank string or an empty collection)
    Parameters:
    property - The property name
    Returns:
    The IsEmpty instance
  - public static IsNotEmpty isNotEmpty(String property)
    
    Used to restrict a value to be not empty (such as a non-blank string)
    Parameters:
    property - The property name
    Returns:
    The IsEmpty instance
  - public static IsNotNull isNotNull(String property)
    
    Used to restrict a value to be null
    Parameters:
    property - The property name
    Returns:
    The IsNull instance
  - public static IsNull isNull(String property)
    
    Used to restrict a value to be null
    Parameters:
    property - The property name
    Returns:
    The IsNull instance
  - public static LessThanEqualsProperty leProperty(String propertyName, String otherPropertyName)
    
    Constraints a property to be less than or equal to a specified other property
    Parameters:
    propertyName - The property
    otherPropertyName - The other property
    Returns:
    The criterion
  - public static Like like(String property, String expression)
    
    Restricts the property match the given String expressions. Expressions use SQL-like % to denote wildcards
    Parameters:
    property - The property name
    expression - The expression
    Returns:
    An instance of Query.Like
  - public static LessThan lt(String property, Object value)
    
    Used to restrict a value to be less than the given value
    Parameters:
    property - The property
    value - The value
    Returns:
    The LessThan instance
  - public static LessThanProperty ltProperty(String propertyName, String otherPropertyName)
    
    Constraints a property to be less than a specified other property
    Parameters:
    propertyName - The property
    otherPropertyName - The other property
    Returns:
    The criterion
  - public static LessThanEquals lte(String property, 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 LessThan instance
  - public static NotEquals ne(String property, Object value)
  - public static NotEqualsProperty neProperty(String propertyName, String otherPropertyName)
    
    Constraints a property to be not equal to a specified other property
    Parameters:
    propertyName - The property
    otherPropertyName - The other property
    Returns:
    This criterion instance
  - public static NotIn notIn(String property, QueryableCriteria subquery)
    
    Restricts the property to be in the list of given values
    Parameters:
    property - The property
    subquery - The subquery
    Returns:
    An instance of Query.In
  - public static Criterion or(Criterion a, Criterion b)
  - public static RLike rlike(String property, String expression)
    
    Restricts the property match the given regular expressions.
    Parameters:
    property - The property name
    expression - The expression
    Returns:
    An instance of Query.RLike
  - public static SizeEquals sizeEq(String property, int size)
    
    Used to restrict the size of a collection property
    Parameters:
    property - The property
    size - The size to restrict
    Returns:
    The result
  - public static SizeGreaterThanEquals sizeGe(String property, int size)
    
    Used to restrict the size of a collection property to be greater than or equal to the given value
    Parameters:
    property - The property
    size - The size to restrict
    Returns:
    The result
  - public static SizeGreaterThan sizeGt(String property, int size)
    
    Used to restrict the size of a collection property to be greater than the given value
    Parameters:
    property - The property
    size - The size to restrict
    Returns:
    The result
  - public static SizeLessThanEquals sizeLe(String property, int size)
    
    Creates a Criterion that contrains a collection property to be less than or equal to the given size
    Parameters:
    property - The property name
    size - The size to constrain by
    Returns:
    A Criterion instance
  - public static SizeLessThan sizeLt(String property, int size)
    
    Creates a Criterion that contrains a collection property to be less than to the given size
    Parameters:
    property - The property name
    size - The size to constrain by
    Returns:
    A Criterion instance
  - public static SizeNotEquals sizeNe(String property, int size)
    
    Creates a Criterion that contrains a collection property to be not equal to the given size
    Parameters:
    property - The property name
    size - The size to constrain by
    Returns:
    A Criterion instance

Summary:
Method

| Detail:
Method

Groovy Documentation

[Java] Class Restrictions

Methods Summary

Inherited Methods Summary

Method Detail

public static Criterion and(Criterion a, Criterion b)

public static Between between(String property, Object start, Object end)

public static Equals eq(String property, Object value)

public static EqualsProperty eqProperty(String propertyName, String otherPropertyName)

public static GreaterThanEqualsProperty geProperty(String propertyName, String otherPropertyName)

public static GreaterThan gt(String property, Object value)

public static GreaterThanProperty gtProperty(String propertyName, String otherPropertyName)

public static GreaterThanEquals gte(String property, Object value)

public static IdEquals idEq(Object value)

public static ILike ilike(String property, String expression)

public static In in(String property, Collection<?> values)

public static In in(String property, QueryableCriteria subquery)

public static IsEmpty isEmpty(String property)

public static IsNotEmpty isNotEmpty(String property)

public static IsNotNull isNotNull(String property)

public static IsNull isNull(String property)

public static LessThanEqualsProperty leProperty(String propertyName, String otherPropertyName)

public static Like like(String property, String expression)

public static LessThan lt(String property, Object value)

public static LessThanProperty ltProperty(String propertyName, String otherPropertyName)

public static LessThanEquals lte(String property, Object value)

public static NotEquals ne(String property, Object value)

public static NotEqualsProperty neProperty(String propertyName, String otherPropertyName)

public static NotIn notIn(String property, QueryableCriteria subquery)

public static Criterion or(Criterion a, Criterion b)

public static RLike rlike(String property, String expression)

public static SizeEquals sizeEq(String property, int size)

public static SizeGreaterThanEquals sizeGe(String property, int size)

public static SizeGreaterThan sizeGt(String property, int size)

public static SizeLessThanEquals sizeLe(String property, int size)

public static SizeLessThan sizeLt(String property, int size)

public static SizeNotEquals sizeNe(String property, int size)