Package org.hibernate.criterion

Class Subqueries

  • public class Subqueries
extends java.lang.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 Criterion eq​(java.lang.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 Criterion eqAll​(java.lang.Object value, DetachedCriteria dc)
      Creates a criterion which checks that the value of a literal equals ALL the values in the subquery result.
      static Criterion exists​(DetachedCriteria dc)
      Creates a criterion which checks for the existence of rows in the subquery result
      static Criterion ge​(java.lang.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 Criterion geAll​(java.lang.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 Criterion geSome​(java.lang.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 Criterion gt​(java.lang.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 Criterion gtAll​(java.lang.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 Criterion gtSome​(java.lang.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 Criterion in​(java.lang.Object value, DetachedCriteria dc)
      Creates a criterion which checks that the value of a literal is IN the values in the subquery result.
      static Criterion le​(java.lang.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 Criterion leAll​(java.lang.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 Criterion leSome​(java.lang.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 Criterion lt​(java.lang.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 Criterion ltAll​(java.lang.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 Criterion ltSome​(java.lang.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 Criterion ne​(java.lang.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 Criterion notExists​(DetachedCriteria dc)
      Creates a criterion which checks for the non-existence of rows in the subquery result
      static Criterion notIn​(java.lang.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 Criterion propertiesEq​(java.lang.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 Criterion propertiesIn​(java.lang.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 Criterion propertiesNotEq​(java.lang.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 Criterion propertiesNotIn​(java.lang.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 Criterion propertyEq​(java.lang.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 Criterion propertyEqAll​(java.lang.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 Criterion propertyGe​(java.lang.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 Criterion propertyGeAll​(java.lang.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 Criterion propertyGeSome​(java.lang.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 Criterion propertyGt​(java.lang.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 Criterion propertyGtAll​(java.lang.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 Criterion propertyGtSome​(java.lang.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 Criterion propertyIn​(java.lang.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 Criterion propertyLe​(java.lang.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 Criterion propertyLeAll​(java.lang.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 Criterion propertyLeSome​(java.lang.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 Criterion propertyLt​(java.lang.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 Criterion propertyLtAll​(java.lang.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 Criterion propertyLtSome​(java.lang.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 Criterion propertyNe​(java.lang.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 Criterion propertyNotIn​(java.lang.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.

      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

    • 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​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertySubqueryExpression

      • propertyGtAll

        public static Criterion propertyGtAll​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertySubqueryExpression

      • propertyLtAll

        public static Criterion propertyLtAll​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertySubqueryExpression

      • propertyGeAll

        public static Criterion propertyGeAll​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertySubqueryExpression

      • propertyLeAll

        public static Criterion propertyLeAll​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertySubqueryExpression

      • propertyGtSome

        public static Criterion propertyGtSome​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertySubqueryExpression

      • propertyLtSome

        public static Criterion propertyLtSome​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertySubqueryExpression

      • propertyGeSome

        public static Criterion propertyGeSome​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertySubqueryExpression

      • propertyLeSome

        public static Criterion propertyLeSome​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertySubqueryExpression

      • propertyIn

        public static Criterion propertyIn​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertySubqueryExpression

      • propertyNotIn

        public static Criterion propertyNotIn​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertySubqueryExpression

      • propertyEq

        public static Criterion propertyEq​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertySubqueryExpression

      • propertyNe

        public static Criterion propertyNe​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertySubqueryExpression

      • propertiesEq

        public static Criterion propertiesEq​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertiesSubqueryExpression

      • propertiesNotEq

        public static Criterion propertiesNotEq​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertiesSubqueryExpression

      • propertiesIn

        public static Criterion propertiesIn​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertiesSubqueryExpression

      • propertiesNotIn

        public static Criterion propertiesNotIn​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertiesSubqueryExpression

      • eqAll

        public static Criterion eqAll​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • gtAll

        public static Criterion gtAll​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • ltAll

        public static Criterion ltAll​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • geAll

        public static Criterion geAll​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • leAll

        public static Criterion leAll​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • gtSome

        public static Criterion gtSome​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • ltSome

        public static Criterion ltSome​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • geSome

        public static Criterion geSome​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • leSome

        public static Criterion leSome​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • in

        public static Criterion in​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • notIn

        public static Criterion notIn​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • eq

        public static Criterion eq​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • ne

        public static Criterion ne​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • gt

        public static Criterion gt​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • lt

        public static Criterion lt​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • ge

        public static Criterion ge​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression

      • le

        public static Criterion le​(java.lang.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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression