public abstract class AbstractHibernateCriteriaBuilder extends groovy.lang.GroovyObjectSupport
Abstract super class for sharing code between Hibernate 3 and 4 implementations of HibernateCriteriaBuilder
Modifiers | Name | Description |
---|---|---|
protected class |
AbstractHibernateCriteriaBuilder.LogicalExpression |
instances of this class are pushed onto the logicalExpressionStack to represent all the unfinished "and", "or", and "not" expressions. |
Modifiers | Name | Description |
---|---|---|
protected static java.lang.String |
ALIAS |
|
static java.lang.String |
AND |
|
static java.lang.String |
BETWEEN |
|
protected static java.lang.String |
COUNT_CALL |
|
static java.lang.String |
EQUALS |
|
static java.lang.String |
EQUALS_PROPERTY |
|
protected static java.lang.String |
GET_CALL |
|
static java.lang.String |
GREATER_THAN |
|
static java.lang.String |
GREATER_THAN_OR_EQUAL |
|
static java.lang.String |
GREATER_THAN_OR_EQUAL_PROPERTY |
|
static java.lang.String |
GREATER_THAN_PROPERTY |
|
static java.lang.String |
ID_EQUALS |
|
static java.lang.String |
ILIKE |
|
static java.lang.String |
IN |
|
static java.lang.String |
IS_EMPTY |
|
static java.lang.String |
IS_NOT_EMPTY |
|
static java.lang.String |
IS_NOT_NULL |
|
static java.lang.String |
IS_NULL |
|
static java.lang.String |
LESS_THAN |
|
static java.lang.String |
LESS_THAN_OR_EQUAL |
|
static java.lang.String |
LESS_THAN_OR_EQUAL_PROPERTY |
|
static java.lang.String |
LESS_THAN_PROPERTY |
|
static java.lang.String |
LIKE |
|
protected static java.lang.String |
LIST_CALL |
|
protected static java.lang.String |
LIST_DISTINCT_CALL |
|
static java.lang.String |
NOT |
|
static java.lang.String |
NOT_EQUAL |
|
static java.lang.String |
NOT_EQUAL_PROPERTY |
|
static java.lang.String |
OR |
|
static java.lang.String |
ORDER_ASCENDING |
|
static java.lang.String |
ORDER_DESCENDING |
|
protected static java.lang.String |
PROJECTIONS |
|
static java.lang.String |
RLIKE |
|
protected static java.lang.String |
ROOT_CALL |
|
protected static java.lang.String |
ROOT_DO_CALL |
|
protected static java.lang.String |
SCROLL_CALL |
|
protected static java.lang.String |
SET_RESULT_TRANSFORMER_CALL |
|
static java.lang.String |
SIZE_EQUALS |
|
protected int |
aliasCount |
|
protected java.util.List<Criteria> |
aliasInstanceStack |
|
protected java.util.Map<java.lang.String, java.lang.String> |
aliasMap |
|
protected java.util.List<java.lang.String> |
aliasStack |
|
protected java.util.List<java.lang.String> |
associationStack |
|
protected org.springframework.core.convert.ConversionService |
conversionService |
|
protected boolean |
count |
|
protected Criteria |
criteria |
|
protected groovy.lang.MetaClass |
criteriaMetaClass |
|
protected AbstractHibernateDatastore |
datastore |
|
protected int |
defaultFlushMode |
|
protected org.hibernate.Session |
hibernateSession |
|
protected java.util.List<org.hibernate.criterion.LogicalExpression> |
logicalExpressionStack |
|
protected java.util.List<org.hibernate.criterion.Order> |
orderEntries |
|
protected boolean |
paginationEnabledList |
|
protected boolean |
participate |
|
protected ProjectionList |
projectionList |
|
protected org.hibernate.transform.ResultTransformer |
resultTransformer |
|
protected boolean |
scroll |
|
protected org.hibernate.SessionFactory |
sessionFactory |
|
protected java.lang.Class<?> |
targetClass |
|
protected boolean |
uniqueResult |
Constructor and description |
---|
AbstractHibernateCriteriaBuilder
(java.lang.Class targetClass, org.hibernate.SessionFactory sessionFactory) |
AbstractHibernateCriteriaBuilder
(java.lang.Class targetClass, org.hibernate.SessionFactory sessionFactory, boolean uniqueResult) |
Type | Name and description |
---|---|
protected void |
addProjectionToList(org.hibernate.criterion.Projection propertyProjection, java.lang.String alias) Adds a projection to the projectList for the given alias |
protected org.hibernate.criterion.Criterion |
addToCriteria(org.hibernate.criterion.Criterion c) adds and returns the given criterion to the currently active criteria set. |
Criteria |
allEq(java.util.Map<java.lang.String, java.lang.Object> propertyValues) |
Criteria |
and(groovy.lang.Closure callable) |
ProjectionList |
avg(java.lang.String propertyName) Adds a projection that allows the criteria to return the property average value |
ProjectionList |
avg(java.lang.String propertyName, java.lang.String alias) Adds a projection that allows the criteria to return the property average value |
Criteria |
between(java.lang.String propertyName, java.lang.Object lo, java.lang.Object hi) Creates a "between" Criterion based on the property name and specified lo and hi values |
Criteria |
buildCriteria(groovy.lang.Closure<?> criteriaClosure) |
BuildableCriteria |
cache(boolean shouldCache) Whether to use the query cache |
protected void |
cacheCriteriaMapping() |
protected java.lang.String |
calculatePropertyName(java.lang.String propertyName) Calculates the property name including any alias paths |
protected java.lang.Object |
calculatePropertyValue(java.lang.Object propertyValue) Calculates the property value, converting GStrings if necessary |
protected java.util.List |
convertArgumentList(java.util.List argList) |
protected org.hibernate.criterion.Order |
convertOrder(Order o, java.lang.String property) |
protected org.hibernate.criterion.DetachedCriteria |
convertToHibernateCriteria(QueryableCriteria<?> queryableCriteria) |
void |
count(java.lang.String propertyName) Adds a projection that allows the criteria to return the property count |
void |
count(java.lang.String propertyName, java.lang.String alias) Adds a projection that allows the criteria to return the property count |
ProjectionList |
count() |
ProjectionList |
countDistinct(java.lang.String propertyName) Adds a projection that allows the criteria to return the distinct property count |
ProjectionList |
countDistinct(java.lang.String propertyName, java.lang.String alias) Adds a projection that allows the criteria to return the distinct property count |
Criteria |
createAlias(java.lang.String associationPath, java.lang.String alias) Join an association, assigning an alias to the joined association. |
Criteria |
createAlias(java.lang.String associationPath, java.lang.String alias, int joinType) Join an association using the specified join-type, assigning an alias to the joined association. |
protected void |
createCriteriaInstance() |
protected java.util.List |
createPagedResultList(java.util.Map args) |
ProjectionList |
distinct(java.lang.String propertyName) A projection that selects a distince property name |
ProjectionList |
distinct(java.lang.String propertyName, java.lang.String alias) A projection that selects a distince property name |
ProjectionList |
distinct(java.util.Collection propertyNames) A distinct projection that takes a list |
ProjectionList |
distinct(java.util.Collection propertyNames, java.lang.String alias) A distinct projection that takes a list |
ProjectionList |
distinct() |
Criteria |
eq(java.lang.String propertyName, java.lang.Object propertyValue) Creates an "equals" Criterion based on the specified property name and value. |
Criteria |
eq(java.util.Map params, java.lang.String propertyName, java.lang.Object propertyValue) Groovy moves the map to the first parameter if using the idiomatic form, e.g. |
Criteria |
eq(java.lang.String propertyName, java.lang.Object propertyValue, java.util.Map params) Creates an "equals" Criterion based on the specified property name and value. |
Criteria |
eqAll(java.lang.String propertyName, groovy.lang.Closure<?> propertyValue) Creates a subquery criterion that ensures the given property is equal to all the given returned values |
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 |
Criteria |
eqProperty(java.lang.String propertyName, java.lang.String otherPropertyName) Creates a Criterion that compares to class properties for equality |
protected Criteria |
executeLogicalExpression(groovy.lang.Closure callable, java.lang.String logicalOperator) |
protected java.lang.Object |
executeUniqueResultWithProxyUnwrap() |
Criteria |
exists(QueryableCriteria<?> subquery) |
void |
fetchMode(java.lang.String associationPath, org.hibernate.FetchMode fetchMode) Sets the fetch mode of an associated path |
Criteria |
ge(java.lang.String propertyName, java.lang.Object propertyValue) Creates a "greater than or equal to" Criterion based on the specified property name and value |
Criteria |
geAll(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 |
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 |
Criteria |
geProperty(java.lang.String propertyName, java.lang.String otherPropertyName) Creates a Criterion that tests if the first property is greater than or equal to the second property |
Criteria |
geSome(java.lang.String propertyName, QueryableCriteria propertyValue) |
Criteria |
geSome(java.lang.String propertyName, groovy.lang.Closure<?> propertyValue) |
java.lang.Object |
get(groovy.lang.Closure c) |
protected java.lang.Class |
getClassForAssociationType(org.hibernate.type.AssociationType type) |
int |
getDefaultFlushMode() |
Criteria |
getInstance() Returns the criteria instance |
java.lang.Class<?> |
getTargetClass() |
ProjectionList |
groupProperty(java.lang.String propertyName) Adds a projection that allows the criteria to return the distinct property count |
ProjectionList |
groupProperty(java.lang.String propertyName, java.lang.String alias) Adds a projection that allows the criteria's result to be grouped by a property |
Criteria |
gt(java.lang.String propertyName, java.lang.Object propertyValue) Creates a "greater than" Criterion based on the specified property name and value |
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 |
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 |
Criteria |
gtProperty(java.lang.String propertyName, java.lang.String otherPropertyName) Creates a Criterion that tests if the first property is greater than the second property |
Criteria |
gtSome(java.lang.String propertyName, QueryableCriteria propertyValue) |
Criteria |
gtSome(java.lang.String propertyName, groovy.lang.Closure<?> propertyValue) |
Criteria |
gte(java.lang.String s, java.lang.Object o) |
ProjectionList |
id() |
Criteria |
idEq(java.lang.Object o) |
Criteria |
idEquals(java.lang.Object o) |
Criteria |
ilike(java.lang.String propertyName, java.lang.Object propertyValue) Creates a Criterion with from the specified property name and "ilike" (a case sensitive version of "like") expression |
Criteria |
in(java.lang.String propertyName, QueryableCriteria<?> subquery) |
Criteria |
in(java.lang.String propertyName, groovy.lang.Closure<?> subquery) |
Criteria |
in(java.lang.String propertyName, java.util.Collection values) Applys a "in" contrain on the specified property |
Criteria |
in(java.lang.String propertyName, java.lang.Object[] values) Applys a "in" contrain on the specified property |
Criteria |
inList(java.lang.String propertyName, QueryableCriteria<?> subquery) |
Criteria |
inList(java.lang.String propertyName, groovy.lang.Closure<?> subquery) |
Criteria |
inList(java.lang.String propertyName, java.util.Collection values) Delegates to in as in is a Groovy keyword |
Criteria |
inList(java.lang.String propertyName, java.lang.Object[] values) Delegates to in as in is a Groovy keyword |
java.lang.Object |
invokeMethod(java.lang.String name, java.lang.Object obj) |
Criteria |
isEmpty(java.lang.String property) |
Criteria |
isNotEmpty(java.lang.String property) |
Criteria |
isNotNull(java.lang.String property) |
Criteria |
isNull(java.lang.String property) |
BuildableCriteria |
join(java.lang.String associationPath) Use a join query |
Criteria |
le(java.lang.String propertyName, java.lang.Object propertyValue) Creates a "less than or equal to" Criterion based on the specified property name and value |
Criteria |
leAll(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 |
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 |
Criteria |
leProperty(java.lang.String propertyName, java.lang.String otherPropertyName) Creates a Criterion that tests if the first property is less than or equal to the second property |
Criteria |
leSome(java.lang.String propertyName, QueryableCriteria propertyValue) |
Criteria |
leSome(java.lang.String propertyName, groovy.lang.Closure<?> propertyValue) |
Criteria |
like(java.lang.String propertyName, java.lang.Object propertyValue) Creates a Criterion with from the specified property name and "like" expression |
java.lang.Object |
list(groovy.lang.Closure c) |
java.lang.Object |
list(java.util.Map params, groovy.lang.Closure c) |
java.lang.Object |
listDistinct(groovy.lang.Closure c) |
void |
lock(boolean shouldLock) Whether a pessimistic lock should be obtained. |
Criteria |
lt(java.lang.String propertyName, java.lang.Object propertyValue) Creates a "less than" Criterion based on the specified property name and value |
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 |
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 |
Criteria |
ltProperty(java.lang.String propertyName, java.lang.String otherPropertyName) Creates a Criterion that tests if the first property is less than the second property |
Criteria |
ltSome(java.lang.String propertyName, QueryableCriteria propertyValue) |
Criteria |
ltSome(java.lang.String propertyName, groovy.lang.Closure<?> propertyValue) |
Criteria |
lte(java.lang.String s, java.lang.Object o) |
ProjectionList |
max(java.lang.String propertyName) Adds a projection that allows the criteria to retrieve a maximum property value |
ProjectionList |
max(java.lang.String propertyName, java.lang.String alias) Adds a projection that allows the criteria to retrieve a maximum property value |
ProjectionList |
min(java.lang.String propertyName) Adds a projection that allows the criteria to retrieve a minimum property value |
ProjectionList |
min(java.lang.String propertyName, java.lang.String alias) Adds a projection that allows the criteria to retrieve a minimum property value |
Criteria |
ne(java.lang.String propertyName, java.lang.Object propertyValue) Creates a "not equal" Criterion based on the specified property name and value |
Criteria |
neProperty(java.lang.String propertyName, java.lang.String otherPropertyName) Creates a Criterion that compares to class properties for ! |
Criteria |
not(groovy.lang.Closure callable) |
Criteria |
notEqual(java.lang.String propertyName, java.lang.Object propertyValue) |
Criteria |
notExists(QueryableCriteria<?> subquery) |
Criteria |
notIn(java.lang.String propertyName, QueryableCriteria<?> subquery) |
Criteria |
notIn(java.lang.String propertyName, groovy.lang.Closure<?> subquery) |
Criteria |
or(groovy.lang.Closure callable) |
Criteria |
order(java.lang.String propertyName) Orders by the specified property name (defaults to ascending) |
Criteria |
order(org.hibernate.criterion.Order o) Orders by the specified property name (defaults to ascending) |
Criteria |
order(Order o) |
Criteria |
order(java.lang.String propertyName, java.lang.String direction) Orders by the specified property name and direction |
ProjectionList |
property(java.lang.String propertyName) A projection that selects a property name |
ProjectionList |
property(java.lang.String propertyName, java.lang.String alias) A projection that selects a property name |
BuildableCriteria |
readOnly(boolean readOnly) Whether to check for changes on the objects loaded |
void |
resultTransformer(org.hibernate.transform.ResultTransformer transformer) Sets the resultTransformer. |
Criteria |
rlike(java.lang.String propertyName, java.lang.Object propertyValue) Creates a Criterion with from the specified property name and "rlike" (a regular expression version of "like") expression |
ProjectionList |
rowCount() Adds a projection that allows the criteria to return the row count |
ProjectionList |
rowCount(java.lang.String alias) Adds a projection that allows the criteria to return the row count |
java.lang.Object |
scroll(groovy.lang.Closure c) |
BuildableCriteria |
select(java.lang.String associationPath) Use a select query |
void |
setConversionService(org.springframework.core.convert.ConversionService conversionService) |
void |
setDatastore(AbstractHibernateDatastore datastore) |
void |
setDefaultFlushMode(int defaultFlushMode) |
void |
setUniqueResult(boolean uniqueResult) Set whether a unique result should be returned |
Criteria |
sizeEq(java.lang.String propertyName, int size) Creates a Criterion that contrains a collection property by size |
Criteria |
sizeGe(java.lang.String propertyName, int size) Creates a Criterion that contrains a collection property to be greater than or equal to the given size |
Criteria |
sizeGt(java.lang.String propertyName, int size) Creates a Criterion that contrains a collection property to be greater than the given size |
Criteria |
sizeLe(java.lang.String propertyName, int size) Creates a Criterion that contrains a collection property to be less than or equal to the given size |
Criteria |
sizeLt(java.lang.String propertyName, int size) Creates a Criterion that contrains a collection property to be less than to the given size |
Criteria |
sizeNe(java.lang.String propertyName, int size) Creates a Criterion that contrains a collection property to be not equal to the given size |
protected void |
sqlGroupProjection(java.lang.String sql, java.lang.String groupBy, java.util.List<java.lang.String> columnAliases, java.util.List<org.hibernate.type.Type> types) Adds a sql projection to the criteria |
protected void |
sqlProjection(java.lang.String sql, java.lang.String columnAlias, org.hibernate.type.Type type) Adds a sql projection to the criteria |
protected void |
sqlProjection(java.lang.String sql, java.util.List<java.lang.String> columnAliases, java.util.List<org.hibernate.type.Type> types) Adds a sql projection to the criteria |
Criteria |
sqlRestriction(java.lang.String sqlRestriction) Applies a sql restriction to the results to allow something like: |
Criteria |
sqlRestriction(java.lang.String sqlRestriction, java.util.List<?> values) Applies a sql restriction to the results to allow something like: |
ProjectionList |
sum(java.lang.String propertyName) Adds a projection that allows the criteria to retrieve the sum of the results of a property |
ProjectionList |
sum(java.lang.String propertyName, java.lang.String alias) Adds a projection that allows the criteria to retrieve the sum of the results of a property |
protected void |
throwRuntimeException(java.lang.RuntimeException t) Throws a runtime exception where necessary to ensure the session gets closed |
protected boolean |
validateSimpleExpression() |
Methods inherited from class | Name |
---|---|
class groovy.lang.GroovyObjectSupport |
groovy.lang.GroovyObjectSupport#setProperty(java.lang.String, java.lang.Object), groovy.lang.GroovyObjectSupport#getProperty(java.lang.String), groovy.lang.GroovyObjectSupport#invokeMethod(java.lang.String, java.lang.Object), groovy.lang.GroovyObjectSupport#setMetaClass(groovy.lang.MetaClass), groovy.lang.GroovyObjectSupport#getMetaClass(), groovy.lang.GroovyObjectSupport#wait(long, int), groovy.lang.GroovyObjectSupport#wait(long), groovy.lang.GroovyObjectSupport#wait(), groovy.lang.GroovyObjectSupport#equals(java.lang.Object), groovy.lang.GroovyObjectSupport#toString(), groovy.lang.GroovyObjectSupport#hashCode(), groovy.lang.GroovyObjectSupport#getClass(), groovy.lang.GroovyObjectSupport#notify(), groovy.lang.GroovyObjectSupport#notifyAll() |
class java.lang.Object |
java.lang.Object#wait(long, int), java.lang.Object#wait(long), java.lang.Object#wait(), java.lang.Object#equals(java.lang.Object), java.lang.Object#toString(), java.lang.Object#hashCode(), java.lang.Object#getClass(), java.lang.Object#notify(), java.lang.Object#notifyAll() |
Adds a projection to the projectList for the given alias
propertyProjection
- The projectionalias
- The aliasadds and returns the given criterion to the currently active criteria set. this might be either the root criteria or a currently open LogicalExpression.
Adds a projection that allows the criteria to return the property average value
propertyName
- The name of the propertyAdds a projection that allows the criteria to return the property average value
propertyName
- The name of the propertyalias
- The alias to useCreates a "between" Criterion based on the property name and specified lo and hi values
propertyName
- The property namelo
- The low valuehi
- The high valueWhether to use the query cache
shouldCache
- True if the query should be cachedCalculates the property name including any alias paths
propertyName
- The property nameCalculates the property value, converting GStrings if necessary
propertyValue
- The property valueAdds a projection that allows the criteria to return the property count
propertyName
- The name of the propertyAdds a projection that allows the criteria to return the property count
propertyName
- The name of the propertyalias
- The alias to useAdds a projection that allows the criteria to return the distinct property count
propertyName
- The name of the propertyAdds a projection that allows the criteria to return the distinct property count
propertyName
- The name of the propertyalias
- The alias to useJoin an association, assigning an alias to the joined association. Functionally equivalent to createAlias(String, String, int) using CriteriaSpecificationINNER_JOIN for the joinType.
associationPath
- A dot-seperated property pathalias
- The alias to assign to the joined association (for later reference).Join an association using the specified join-type, assigning an alias to the joined association. sub The joinType is expected to be one of CriteriaSpecification.INNER_JOIN (the default), CriteriaSpecificationFULL_JOIN, or CriteriaSpecificationLEFT_JOIN.
associationPath
- A dot-seperated property pathalias
- The alias to assign to the joined association (for later reference).joinType
- The type of join to use.A projection that selects a distince property name
propertyName
- The property nameA projection that selects a distince property name
propertyName
- The property namealias
- The alias to useA distinct projection that takes a list
propertyNames
- The list of distince property namesA distinct projection that takes a list
propertyNames
- The list of distince property namesalias
- The alias to useCreates an "equals" Criterion based on the specified property name and value. Case-sensitive.
propertyName
- The property namepropertyValue
- The property value Groovy moves the map to the first parameter if using the idiomatic form, e.g.
eq 'firstName', 'Fred', ignoreCase: true
.
params
- optional map with customization parameters; currently only 'ignoreCase' is supported. Creates an "equals" Criterion based on the specified property name and value.
Supports case-insensitive search if the params
map contains true
under the 'ignoreCase' key.
propertyName
- The property namepropertyValue
- The property valueparams
- optional map with customization parameters; currently only 'ignoreCase' is supported.Creates a subquery criterion that ensures the given property is equal to all the given returned values
propertyName
- The property namepropertyValue
- The property valueCreates a subquery criterion that ensures the given property is equal to all the given returned values
propertyName
- The property namepropertyValue
- The property valueCreates a Criterion that compares to class properties for equality
propertyName
- The first property nameotherPropertyName
- The second property nameSets the fetch mode of an associated path
associationPath
- The name of the associated pathfetchMode
- The fetch mode to setCreates a "greater than or equal to" Criterion based on the specified property name and value
propertyName
- The property namepropertyValue
- The property valueCreates a subquery criterion that ensures the given property is greater than all the given returned values
propertyName
- The property namepropertyValue
- The property valueCreates a subquery criterion that ensures the given property is greater than all the given returned values
propertyName
- The property namepropertyValue
- The property valueCreates a Criterion that tests if the first property is greater than or equal to the second property
propertyName
- The first property nameotherPropertyName
- The second property nameReturns the criteria instance
Adds a projection that allows the criteria to return the distinct property count
propertyName
- The name of the propertyAdds a projection that allows the criteria's result to be grouped by a property
propertyName
- The name of the propertyalias
- The alias to useCreates a "greater than" Criterion based on the specified property name and value
propertyName
- The property namepropertyValue
- The property valueCreates a subquery criterion that ensures the given property is greater than all the given returned values
propertyName
- The property namepropertyValue
- The property valueCreates a subquery criterion that ensures the given property is greater than all the given returned values
propertyName
- The property namepropertyValue
- The property valueCreates a Criterion that tests if the first property is greater than the second property
propertyName
- The first property nameotherPropertyName
- The second property nameCreates a Criterion with from the specified property name and "ilike" (a case sensitive version of "like") expression
propertyName
- The property namepropertyValue
- The ilike valueApplys a "in" contrain on the specified property
propertyName
- The property namevalues
- A collection of valuesApplys a "in" contrain on the specified property
propertyName
- The property namevalues
- A collection of valuesDelegates to in as in is a Groovy keyword
Delegates to in as in is a Groovy keyword
Use a join query
associationPath
- The path of the associationCreates a "less than or equal to" Criterion based on the specified property name and value
propertyName
- The property namepropertyValue
- The property valueCreates a subquery criterion that ensures the given property is less than all the given returned values
propertyName
- The property namepropertyValue
- The property valueCreates a subquery criterion that ensures the given property is less than all the given returned values
propertyName
- The property namepropertyValue
- The property valueCreates a Criterion that tests if the first property is less than or equal to the second property
propertyName
- The first property nameotherPropertyName
- The second property nameCreates a Criterion with from the specified property name and "like" expression
propertyName
- The property namepropertyValue
- The like valueWhether a pessimistic lock should be obtained.
shouldLock
- True if it shouldCreates a "less than" Criterion based on the specified property name and value
propertyName
- The property namepropertyValue
- The property valueCreates a subquery criterion that ensures the given property is less than all the given returned values
propertyName
- The property namepropertyValue
- The property valueCreates a subquery criterion that ensures the given property is less than all the given returned values
propertyName
- The property namepropertyValue
- The property valueCreates a Criterion that tests if the first property is less than the second property
propertyName
- The first property nameotherPropertyName
- The second property nameAdds a projection that allows the criteria to retrieve a maximum property value
propertyName
- The name of the propertyAdds a projection that allows the criteria to retrieve a maximum property value
propertyName
- The name of the propertyalias
- The alias to useAdds a projection that allows the criteria to retrieve a minimum property value
propertyName
- The name of the propertyAdds a projection that allows the criteria to retrieve a minimum property value
alias
- The alias to useCreates a "not equal" Criterion based on the specified property name and value
propertyName
- The property namepropertyValue
- The property valueCreates a Criterion that compares to class properties for !equality
propertyName
- The first property nameotherPropertyName
- The second property nameOrders by the specified property name (defaults to ascending)
propertyName
- The property name to order byOrders by the specified property name (defaults to ascending)
o
- The property name to order byOrders by the specified property name and direction
propertyName
- The property name to order bydirection
- Either "asc" for ascending or "desc" for descendingA projection that selects a property name
propertyName
- The name of the propertyA projection that selects a property name
propertyName
- The name of the propertyalias
- The alias to useWhether to check for changes on the objects loaded
readOnly
- True to disable dirty checkingSets the resultTransformer.
transformer
- The result transformer to use.Creates a Criterion with from the specified property name and "rlike" (a regular expression version of "like") expression
propertyName
- The property namepropertyValue
- The ilike valueAdds a projection that allows the criteria to return the row count
Adds a projection that allows the criteria to return the row count
alias
- The alias to useUse a select query
associationPath
- The path of the associationSet whether a unique result should be returned
uniqueResult
- True if a unique result should be returnedCreates a Criterion that contrains a collection property by size
propertyName
- The property namesize
- The size to constrain byCreates a Criterion that contrains a collection property to be greater than or equal to the given size
propertyName
- The property namesize
- The size to constrain byCreates a Criterion that contrains a collection property to be greater than the given size
propertyName
- The property namesize
- The size to constrain byCreates a Criterion that contrains a collection property to be less than or equal to the given size
propertyName
- The property namesize
- The size to constrain byCreates a Criterion that contrains a collection property to be less than to the given size
propertyName
- The property namesize
- The size to constrain byCreates a Criterion that contrains a collection property to be not equal to the given size
propertyName
- The property namesize
- The size to constrain byAdds a sql projection to the criteria
sql
- SQL projectinggroupBy
- group by clausecolumnAliases
- List of column aliases for the projected valuestypes
- List of types for the projected valuesAdds a sql projection to the criteria
sql
- SQL projecting a single valuecolumnAlias
- column alias for the projected valuetype
- the type of the projected valueAdds a sql projection to the criteria
sql
- SQL projectingcolumnAliases
- List of column aliases for the projected valuestypes
- List of types for the projected valuesApplies a sql restriction to the results to allow something like:
sqlRestriction
- the sql restrictionApplies a sql restriction to the results to allow something like:
sqlRestriction
- the sql restrictionvalues
- jdbc parametersAdds a projection that allows the criteria to retrieve the sum of the results of a property
propertyName
- The name of the propertyAdds a projection that allows the criteria to retrieve the sum of the results of a property
propertyName
- The name of the propertyalias
- The alias to useThrows a runtime exception where necessary to ensure the session gets closed