7 | nullif(x, y)Method javax.persistence.criteria.CriteriaBuilder Expression<Y> nullif( Expression<Y> x, Expression<?> y ) Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not. Parameters: x - expression y - expression Returns: nullif expression Since: JPA 2.0 |
7 | nullif(x, y)Method javax.persistence.criteria.CriteriaBuilder Expression<T> nullif( Expression<T> x, Expression<T> y ) Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not. Parameters: x - expression y - expression Returns: nullif expression Since: JPA 2.0 |
7 | coalesce() expression. Returns: coalesce expression Since: JPA 2.0 Selection<X> alias(String name) Assigns an alias ... a predicate to test whether the expression is not null. Create a predicate to test whether the expression is not null. Returns: predicate testing whether the expression is not null Since: JPA 2.0 Predicate |
7 | trim(ts, t, x)Method javax.persistence.criteria.CriteriaBuilder Expression<String> trim( Trimspec ts, Expression<Character> t, Expression<String> x ) Create expression to trim character from a string. Parameters: ts - trim specification t - expression for character to be trimmed x - expression for string to trim Returns: trim expression Since: JPA 2.0 |
7 | trim(t, x)Method javax.persistence.criteria.CriteriaBuilder Expression<String> trim( Expression<Character> t, Expression<String> x ) Create expression to trim character from both ends of a string. Parameters: t - expression for character to be trimmed x - expression for string to trim Returns: trim expression Since: JPA 2.0 |
7 | concat(x, y)Method javax.persistence.criteria.CriteriaBuilder Expression<String> concat( Expression<String> x, Expression<String> y ) Create an expression for string concatenation. Parameters: x - string expression y - string expression Returns: expression corresponding to concatenation Since: JPA 2.0 |
7 | coalesce(x, y)Method javax.persistence.criteria.CriteriaBuilder Expression<Y> coalesce( Expression<?> x, Expression<?> y ) Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise. Parameters: x - expression y - expression Returns: coalesce expression Since: JPA 2.0 |
7 | notLike(x, pattern, escapeChar)Method javax.persistence.criteria.CriteriaBuilder Predicate notLike( Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar ) Create a predicate for testing whether the expression does not satisfy the given pattern. Parameters: x - string expression pattern - string |
7 | locate(x, pattern)Method javax.persistence.criteria.CriteriaBuilder Expression<Integer> locate( Expression<String> x, Expression<String> pattern ) Create expression to locate the position of one string ... . If the string to be located is not found, 0 is returned. Parameters: x - expression for string |
7 | substring(x, from)Method javax.persistence.criteria.CriteriaBuilder Expression<String> substring( Expression<String> x, Expression<Integer> from ) Create an expression for substring extraction. Extracts a substring ... - string expression from - start position expression Returns: expression corresponding to substring extraction Since: JPA 2.0 |
