How to use

org.hibernate.criterion.PropertySubqueryExpression

constructor

/**
 * Creates a criterion which checks that the value of a given property is in the set of values in the
 * subquery result.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 */
public static Criterion propertyIn(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, "in", null, dc );
}

/**
 * Creates a criterion which checks that the value of a given property is greater-than ALL the values in the
 * subquery result.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 */
public static Criterion propertyGtAll(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, ">", "all", dc );
}

/**
 * Creates a criterion which checks that the value of a given property equals ALL the values in the
 * subquery result.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 */
public static Criterion propertyEqAll(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, "=", "all", dc );
}

/**
 * Creates a criterion which checks that the value of a given property is less-than ALL the values in the
 * subquery result.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 */
public static Criterion propertyLtAll(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, "<", "all", dc );
}

/**
 * Creates a criterion which checks that the value of a given property is not-in the set of values in
 * the subquery result.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 */
public static Criterion propertyNotIn(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, "not in", null, 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..
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 */
public static Criterion propertyEq(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, "=", null, 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.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 */
public static Criterion propertyNe(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression(propertyName, "<>", null, dc);
}

/**
 * Creates a criterion which checks that the value of a given property is less-than SOME of the
 * values in the subquery result.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 */
public static Criterion propertyLtSome(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, "<", "some", 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.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 */
public static Criterion propertyLeSome(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, "<=", "some", 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.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 */
public static Criterion propertyGeAll(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, ">=", "all", 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.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 */
public static Criterion propertyLeAll(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, "<=", "all", dc );
}

/**
 * Creates a criterion which checks that the value of a given property is greater-than SOME of the
 * values in the subquery result.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 */
public static Criterion propertyGtSome(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, ">", "some", 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.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 */
public static Criterion propertyGeSome(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, ">=", "some", 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.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 * @see #propertyGtAll
 * @see #propertyGtSome
 */
public static Criterion propertyGt(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, ">", null, 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.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 * @see #propertyLtAll
 * @see #propertyLtSome
 */
public static Criterion propertyLt(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, "<", null, 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.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 * @see #propertyGeAll
 * @see #propertyGeSome
 */
public static Criterion propertyGe(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, ">=", null, 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.
 *
 * @param propertyName The name of the property to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see PropertySubqueryExpression
 * @see #propertyLeAll
 * @see #propertyLeSome
 */
public static Criterion propertyLe(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression( propertyName, "<=", null, dc );
}

public static Criterion propertyIn(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression(propertyName, "in", null, dc);
}

public static Criterion propertyGtAll(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression(propertyName, ">", "all", dc);
}
 

public static Criterion propertyLtAll(String propertyName, DetachedCriteria dc) {
  return new PropertySubqueryExpression(propertyName, "<", "all", dc);
}