ObjectDB Database Search

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate lt (    Expression x ,    Expression y ) Create a predicate for testing whether the first argument is less than the second. Parameters: x - expression y - expression Returns: less-than predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate le (    Expression x ,    Expression y ) Create a predicate for testing whether the first argument is less than or equal to the second. Parameters: x - expression y - expression Returns

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate equal (    Expression x ,    Expression y ) Create a predicate for testing the arguments for equality. Parameters: x - expression y - expression Returns: equality predicate. Since: Jakarta Persistence (JPA) 1.0

greaterThanOrEqualTo (    Expression x ,    Expression y ) Create a predicate for testing whether the first argument is greater than or equal to the second. Parameters: x - expression y - expression Returns: greater-than-or-equal predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate lessThan (    Expression x ,    Expression y ) Create a predicate for testing whether the first argument is less than the second. Parameters: x - expression y - expression Returns: less-than predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate notEqual (    Expression x ,    Expression y ) Create a predicate for testing the arguments for inequality. Parameters: x - expression y - expression Returns: inequality predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate greaterThan (    Expression x ,    Expression y ) Create a predicate for testing whether the first argument is greater than the second. Parameters: x - expression y - expression Returns

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria. Expression Predicate notEqualTo (    Expression value ) Create a predicate to test whether the expression is unequal to the argument. Parameters: value - expression to be tested against Returns: predicate testing for inequality. Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria. Expression Predicate in (    Expression ... values ) Create a predicate to test whether the expression is a member of the argument list. Parameters: values - expressions to be tested against Returns: predicate testing for membership. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria. Expression Predicate equalTo (    Expression value ) Create a predicate to test whether the expression is equal to the argument. Parameters: value - expression to be tested against Returns: predicate testing for equality. Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria. Expression Predicate in (    Expression values ) Create a predicate to test whether the expression is a member of the collection. Parameters: values - expression corresponding to collection to be tested against Returns

the result. Although ObjectDB allows JPQL expressions almost anywhere in a query, the preceding query ... expressions are guaranteed to be supported in the GROUP BY clause across all JPA implementations ... keyword in a COUNT aggregate expression eliminates duplicate values from the count. Only the COUNT

Logical operators in JPQL and JPA criteria queries combine simple Boolean expressions to form complex expressions . Logical operators ObjectDB supports two sets of logical operators, as shown in ... the expression false. If one operand is NULL and the other is TRUE or NULL , the result is NULL

expression . After building the CriteriaQuery , you use it to create a TypedQuery object ... supports method chaining. For details on setting clauses and building expressions , see the links in ... that also cover string-based JPQL queries. Criteria query expressions JPA query clauses consist

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria. Expression Expression cast (    Class type ) Cast this expression to the specified type, returning a new expression object. Unlike Expression .as , this method does result in a runtime type conversion. Providers are required

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria. Expression Expression as (    Class type ) Perform a typecast upon the expression , returning a new expression object. Unlike Expression .cast , this method does not cause type conversion: the runtime type is not changed

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression nullif (    Expression x ,    Y 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

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sumAsLong (    Expression x ) Create an aggregate expression applying the sum operation to an Integer-valued expression , returning a Long result. Parameters: x - expression representing input

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sumAsDouble (    Expression x ) Create an aggregate expression applying the sum operation to a Float-valued expression , returning a Double result. Parameters: x - expression representing input

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Order asc (    Expression expression ) Create an ordering by the ascending value of the expression . Parameters: expression - expression used to define the ordering Returns: ascending ordering corresponding to the expression . Since: Jakarta Persistence (JPA) 1.0

(    Expression expression ) Create an ordering by the descending value of the expression . Parameters: expression - expression used to define the ordering Returns: descending ordering corresponding to the expression . Since: Jakarta Persistence (JPA) 1.0

;  Expression expression ,    Nulls nullPrecedence ) Create an ordering by the ascending value of the expression . Parameters: expression - expression used to define the ordering nullPrecedence - the precedence of null values Returns: ascending ordering corresponding to the expression . Since: Jakarta Persistence (JPA) 3.2

(    Expression expression ,    Nulls nullPrecedence ) Create an ordering by the descending value of the expression . Parameters: expression - expression used to define the ordering nullPrecedence - the precedence of null values Returns: descending ordering corresponding to the expression . Since: Jakarta Persistence (JPA) 3.2

;  Expression ... grouping ) Specify the expressions that are used to form groups over the subquery results. Replaces the previous specified grouping expressions , if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. This method

groupBy (    Expression ... grouping ) Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions , if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. Parameters

groupBy (    Expression ... grouping ) Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions , if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. This method

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder SimpleCase selectCase (    Expression expression ) Create a simple case expression . Parameters: expression - to be tested against the case conditions Returns: simple case expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression avg (    Expression x ) Create an aggregate expression applying the avg operation. Parameters: x - expression representing input value to avg operation Returns: avg expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sum (    Expression x ) Create an aggregate expression applying the sum operation. Parameters: x - expression representing input value to sum operation Returns: sum expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression substring (    Expression x ,    int from ) Create an expression for substring ... position is 1. Parameters: x - string expression from - start position Returns: expression

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression substring (    Expression x ,    int from ,    int len ) Create an expression for substring extraction. Extracts a substring of given length starting at the specified position

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression concat (    Expression x ,    String y ) Create an expression for string concatenation. Parameters: x - string expression y - string Returns: expression corresponding to concatenation. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression concat (    String x ,    Expression y ) Create an expression for string concatenation. Parameters: x - string y - string expression Returns: expression corresponding to concatenation. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression trim (    char t ,    Expression x ) Create expression to trim character from both ends of a string. Parameters: x - expression for string to trim t - character to be trimmed Returns

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression trim (    Trimspec ts ,    char t ,    Expression x ) Create expression to trim character from a string. Parameters: x - expression for string to trim t - character

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression lower (    Expression x ) Create expression for converting a string to lowercase. Parameters: x - string expression Returns: expression to convert to lowercase. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression upper (    Expression x ) Create expression for converting a string to uppercase. Parameters: x - string expression Returns: expression to convert to uppercase. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression trim (    Expression x ) Create expression to trim blanks from both ends of a string. Parameters: x - expression for string to trim Returns: trim expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression trim (    Trimspec ts ,    Expression x ) Create expression to trim blanks from a string. Parameters: x - expression for string to trim ts - trim specification Returns: trim expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression length (    Expression x ) Create expression to return length of a string. Parameters: x - string expression Returns: length expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression left (    Expression x ,    int len ) Create an expression for the leftmost substring of a string, Parameters: x - string expression len - length of the substring to return Returns

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression right (    Expression x ,    int len ) Create an expression for the rightmost substring of a string, Parameters: x - string expression len - length of the substring to return Returns

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression toLong (    Expression number ) Typecast. Returns same expression object. Parameters: number - numeric expression Returns: Expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression toBigInteger (    Expression number ) Typecast. Returns same expression object. Parameters: number - numeric expression Returns: Expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression toString (    Expression character ) Typecast. Returns same expression object. Parameters: character - expression Returns: Expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder.Case Expression otherwise (    Expression result ) Add an "else" clause to the case expression . Parameters: result - "else" result expression Returns: expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression toInteger (    Expression number ) Typecast. Returns same expression object. Parameters: number - numeric expression Returns: Expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression toFloat (    Expression number ) Typecast. Returns same expression object. Parameters: number - numeric expression Returns: Expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression toDouble (    Expression number ) Typecast. Returns same expression object. Parameters: number - numeric expression Returns: Expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder.SimpleCase Expression otherwise (    Expression result ) Add an "else" clause to the case expression . Parameters: result - "else" result expression Returns: expression . Since: Jakarta Persistence (JPA) 1.0