Package org.hibernate.criterion
Class Subqueries
- java.lang.Object
-
- org.hibernate.criterion.Subqueries
-
public class Subqueries extends Object
Factory class for criterion instances that represent expressions involving subqueries.- See Also:
Restrictions,Projection,Criteria
-
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static Criterioneq(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a given literal as being equal to the value in the subquery result.static CriterioneqAll(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a literal equals ALL the values in the subquery result.static Criterionexists(DetachedCriteria dc)Creates a criterion which checks for the existence of rows in the subquery resultstatic Criterionge(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a given literal as being greater-than-or-equal-to the value in the subquery result.static CriteriongeAll(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a literal is greater-than-or-equal-to ALL the values in the subquery result.static CriteriongeSome(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a literal is greater-than-or-equal-to SOME of the values in the subquery result.static Criteriongt(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a given literal as being greater-than the value in the subquery result.static CriteriongtAll(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a literal is greater-than ALL the values in the subquery result.static CriteriongtSome(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a literal is greater-than SOME of the values in the subquery result.static Criterionin(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a literal is IN the values in the subquery result.static Criterionle(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a given literal as being less-than-or-equal-to the value in the subquery result.static CriterionleAll(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a literal is less-than-or-equal-to ALL the values in the subquery result.static CriterionleSome(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a literal is less-than-or-equal-to SOME of the values in the subquery result.static Criterionlt(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a given literal as being less-than the value in the subquery result.static CriterionltAll(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a literal is less-than ALL the values in the subquery result.static CriterionltSome(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a literal is less-than SOME of the values in the subquery result.static Criterionne(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a given literal as being not-equal to the value in the subquery result.static CriterionnotExists(DetachedCriteria dc)Creates a criterion which checks for the non-existence of rows in the subquery resultstatic CriterionnotIn(Object value, DetachedCriteria dc)Creates a criterion which checks that the value of a literal is NOT IN the values in the subquery result.static CriterionpropertiesEq(String[] propertyNames, DetachedCriteria dc)Creates a criterion which checks that the value of multiple given properties as being equal to the set of values in the subquery result.static CriterionpropertiesIn(String[] propertyNames, DetachedCriteria dc)Creates a criterion which checks that the value of multiple given properties as being in to the set of values in the subquery result.static CriterionpropertiesNotEq(String[] propertyNames, DetachedCriteria dc)Creates a criterion which checks that the value of multiple given properties as being not-equal to the set of values in the subquery result.static CriterionpropertiesNotIn(String[] propertyNames, DetachedCriteria dc)Creates a criterion which checks that the value of multiple given properties as being not-in to the set of values in the subquery result.static CriterionpropertyEq(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property as being equal to the set of values in the subquery result.static CriterionpropertyEqAll(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property equals ALL the values in the subquery result.static CriterionpropertyGe(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property is greater-than-or-equal-to the value in the subquery result.static CriterionpropertyGeAll(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property is greater-than-or-equal-to ALL the values in the subquery result.static CriterionpropertyGeSome(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property is greater-than-or-equal-to SOME of the values in the subquery result.static CriterionpropertyGt(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property is greater-than the value in the subquery result.static CriterionpropertyGtAll(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property is greater-than ALL the values in the subquery result.static CriterionpropertyGtSome(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property is greater-than SOME of the values in the subquery result.static CriterionpropertyIn(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property is in the set of values in the subquery result.static CriterionpropertyLe(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property is less-than-or-equal-to the value in the subquery result.static CriterionpropertyLeAll(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property is less-than-or-equal-to ALL the values in the subquery result.static CriterionpropertyLeSome(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property is less-than-or-equal-to SOME of the values in the subquery result.static CriterionpropertyLt(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property is less-than the value in the subquery result.static CriterionpropertyLtAll(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property is less-than ALL the values in the subquery result.static CriterionpropertyLtSome(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property is less-than SOME of the values in the subquery result.static CriterionpropertyNe(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property is not equal to the value in the subquery result.static CriterionpropertyNotIn(String propertyName, DetachedCriteria dc)Creates a criterion which checks that the value of a given property is not-in the set of values in the subquery result.
-
-
-
Method Detail
-
exists
public static Criterion exists(DetachedCriteria dc)
Creates a criterion which checks for the existence of rows in the subquery result- Parameters:
dc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
ExistsSubqueryExpression
-
notExists
public static Criterion notExists(DetachedCriteria dc)
Creates a criterion which checks for the non-existence of rows in the subquery result- Parameters:
dc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
ExistsSubqueryExpression
-
propertyEqAll
public static Criterion propertyEqAll(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property equals ALL the values in the subquery result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyGtAll
public static Criterion propertyGtAll(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property is greater-than ALL the values in the subquery result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyLtAll
public static Criterion propertyLtAll(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property is less-than ALL the values in the subquery result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyGeAll
public static Criterion propertyGeAll(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property is greater-than-or-equal-to ALL the values in the subquery result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyLeAll
public static Criterion propertyLeAll(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property is less-than-or-equal-to ALL the values in the subquery result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyGtSome
public static Criterion propertyGtSome(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property is greater-than SOME of the values in the subquery result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyLtSome
public static Criterion propertyLtSome(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property is less-than SOME of the values in the subquery result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyGeSome
public static Criterion propertyGeSome(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property is greater-than-or-equal-to SOME of the values in the subquery result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyLeSome
public static Criterion propertyLeSome(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property is less-than-or-equal-to SOME of the values in the subquery result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyIn
public static Criterion propertyIn(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property is in the set of values in the subquery result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyNotIn
public static Criterion propertyNotIn(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property is not-in the set of values in the subquery result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyEq
public static Criterion propertyEq(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property as being equal to the set of values in the subquery result. The implication is that the subquery returns a single result..- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyNe
public static Criterion propertyNe(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property is not equal to the value in the subquery result. The assumption is that the subquery returns a single result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyGt
public static Criterion propertyGt(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property is greater-than the value in the subquery result. The assumption is that the subquery returns a single result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression,propertyGtAll(java.lang.String, org.hibernate.criterion.DetachedCriteria),propertyGtSome(java.lang.String, org.hibernate.criterion.DetachedCriteria)
-
propertyLt
public static Criterion propertyLt(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property is less-than the value in the subquery result. The assumption is that the subquery returns a single result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression,propertyLtAll(java.lang.String, org.hibernate.criterion.DetachedCriteria),propertyLtSome(java.lang.String, org.hibernate.criterion.DetachedCriteria)
-
propertyGe
public static Criterion propertyGe(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property is greater-than-or-equal-to the value in the subquery result. The assumption is that the subquery returns a single result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression,propertyGeAll(java.lang.String, org.hibernate.criterion.DetachedCriteria),propertyGeSome(java.lang.String, org.hibernate.criterion.DetachedCriteria)
-
propertyLe
public static Criterion propertyLe(String propertyName, DetachedCriteria dc)
Creates a criterion which checks that the value of a given property is less-than-or-equal-to the value in the subquery result. The assumption is that the subquery returns a single result.- Parameters:
propertyName- The name of the property to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression,propertyLeAll(java.lang.String, org.hibernate.criterion.DetachedCriteria),propertyLeSome(java.lang.String, org.hibernate.criterion.DetachedCriteria)
-
propertiesEq
public static Criterion propertiesEq(String[] propertyNames, DetachedCriteria dc)
Creates a criterion which checks that the value of multiple given properties as being equal to the set of values in the subquery result. The implication is that the subquery returns a single result. This form is however implicitly using tuple comparisons- Parameters:
propertyNames- The names of the properties to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertiesSubqueryExpression
-
propertiesNotEq
public static Criterion propertiesNotEq(String[] propertyNames, DetachedCriteria dc)
Creates a criterion which checks that the value of multiple given properties as being not-equal to the set of values in the subquery result. The assumption is that the subquery returns a single result. This form is however implicitly using tuple comparisons- Parameters:
propertyNames- The names of the properties to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertiesSubqueryExpression
-
propertiesIn
public static Criterion propertiesIn(String[] propertyNames, DetachedCriteria dc)
Creates a criterion which checks that the value of multiple given properties as being in to the set of values in the subquery result. This form is implicitly using tuple comparisons- Parameters:
propertyNames- The names of the properties to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertiesSubqueryExpression
-
propertiesNotIn
public static Criterion propertiesNotIn(String[] propertyNames, DetachedCriteria dc)
Creates a criterion which checks that the value of multiple given properties as being not-in to the set of values in the subquery result. This form is implicitly using tuple comparisons- Parameters:
propertyNames- The names of the properties to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertiesSubqueryExpression
-
eqAll
public static Criterion eqAll(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a literal equals ALL the values in the subquery result.- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
gtAll
public static Criterion gtAll(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a literal is greater-than ALL the values in the subquery result.- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
ltAll
public static Criterion ltAll(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a literal is less-than ALL the values in the subquery result.- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
geAll
public static Criterion geAll(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a literal is greater-than-or-equal-to ALL the values in the subquery result.- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
leAll
public static Criterion leAll(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a literal is less-than-or-equal-to ALL the values in the subquery result.- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
gtSome
public static Criterion gtSome(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a literal is greater-than SOME of the values in the subquery result.- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
ltSome
public static Criterion ltSome(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a literal is less-than SOME of the values in the subquery result.- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
geSome
public static Criterion geSome(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a literal is greater-than-or-equal-to SOME of the values in the subquery result.- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
leSome
public static Criterion leSome(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a literal is less-than-or-equal-to SOME of the values in the subquery result.- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
in
public static Criterion in(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a literal is IN the values in the subquery result.- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
notIn
public static Criterion notIn(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a literal is NOT IN the values in the subquery result.- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
eq
public static Criterion eq(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a given literal as being equal to the value in the subquery result. The implication is that the subquery returns a single result..- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
ne
public static Criterion ne(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a given literal as being not-equal to the value in the subquery result. The implication is that the subquery returns a single result..- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
gt
public static Criterion gt(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a given literal as being greater-than the value in the subquery result. The implication is that the subquery returns a single result..- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
lt
public static Criterion lt(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a given literal as being less-than the value in the subquery result. The implication is that the subquery returns a single result..- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
ge
public static Criterion ge(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a given literal as being greater-than-or-equal-to the value in the subquery result. The implication is that the subquery returns a single result..- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
le
public static Criterion le(Object value, DetachedCriteria dc)
Creates a criterion which checks that the value of a given literal as being less-than-or-equal-to the value in the subquery result. The implication is that the subquery returns a single result..- Parameters:
value- The literal value to use in comparisondc- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
-