/** * Equal To - property equal to the given value. */ public static Expression eq(String propertyName, Object value) { return Ebean.getExpressionFactory().eq(propertyName, value); }
/** * Less Than or Equal to - property less than or equal to the given value. */ public static Expression le(String propertyName, Object value) { return Ebean.getExpressionFactory().le(propertyName, value); }
/** * Case insensitive Like - property like value where the value contains the * SQL wild card characters % (percentage) and _ (underscore). Typically uses * a lower() function to make the expression case insensitive. */ public static Expression ilike(String propertyName, String value) { return Ebean.getExpressionFactory().ilike(propertyName, value); }
/** * Id Equal to - ID property is equal to the value. */ public static Expression idEq(Object value) { return Ebean.getExpressionFactory().idEq(value); }
/** * Add raw expression with no parameters. */ public static Expression raw(String raw) { return Ebean.getExpressionFactory().raw(raw); }
/** * Not Equal To - property not equal to the given value. */ public static Expression ne(String propertyName, Object value) { return Ebean.getExpressionFactory().ne(propertyName, value); }
/** * Case Insensitive Equal To - property equal to the given value (typically * using a lower() function to make it case insensitive). */ public static Expression ieq(String propertyName, String value) { return Ebean.getExpressionFactory().ieq(propertyName, value); }
/** * Greater Than or Equal to - property greater than or equal to the given * value. */ public static Expression ge(String propertyName, Object value) { return Ebean.getExpressionFactory().ge(propertyName, value); }
/** * Less Than - property less than the given value. */ public static Expression lt(String propertyName, Object value) { return Ebean.getExpressionFactory().lt(propertyName, value); }
/** * For collection properties that are empty (have not existing elements). */ public static Expression isEmpty(String propertyName) { return Ebean.getExpressionFactory().isEmpty(propertyName); }
/** * In - property has a value in the array of values. */ public static Expression in(String propertyName, Object[] values) { return Ebean.getExpressionFactory().in(propertyName, values); }
/** * In - property has a value in the collection of values. */ public static Expression in(String propertyName, Collection<?> values) { return Ebean.getExpressionFactory().in(propertyName, values); }
/** * And - join two expressions with a logical and. */ public static Expression and(Expression expOne, Expression expTwo) { return Ebean.getExpressionFactory().and(expOne, expTwo); }
/** * In Range - property >= value1 and property < value2. * <p> * Unlike Between inRange is "half open" and usually more useful for use with dates or timestamps. * </p> */ public static Expression inRange(String propertyName, Object value1, Object value2) { return Ebean.getExpressionFactory().inRange(propertyName, value1, value2); }
/** * Between - property between the two given values. */ public static Expression between(String propertyName, Object value1, Object value2) { return Ebean.getExpressionFactory().between(propertyName, value1, value2); }
/** * Create the query by Example expression which is case sensitive and using * LikeType.RAW (you need to add you own wildcards % and _). */ public static ExampleExpression exampleLike(Object example) { return Ebean.getExpressionFactory().exampleLike(example); }
/** * Like - property like value where the value contains the SQL wild card * characters % (percentage) and _ (underscore). */ public static Expression like(String propertyName, String value) { return Ebean.getExpressionFactory().like(propertyName, value); }
/** * Contains - property like %value%. */ public static Expression contains(String propertyName, String value) { return Ebean.getExpressionFactory().contains(propertyName, value); }
/** * Add raw expression with a single parameter. * <p> * The raw expression should contain a single ? at the location of the * parameter. * </p> */ public static Expression raw(String raw, Object value) { return Ebean.getExpressionFactory().raw(raw, value); }
/** * Add raw expression with an array of parameters. * <p> * The raw expression should contain the same number of ? as there are * parameters. * </p> */ public static Expression raw(String raw, Object[] values) { return Ebean.getExpressionFactory().raw(raw, values); }