ObjectDB Database Search

does not support regular expressions in queries, so currently you cannot use regular expressions in ... so you can use regular expressions in queries, just use string-based JPQL ("e.g. e.field.matches(regexp)") instead of criteria queries. support Support ... I'm struggling to understand how to use the matches method on the String class when using regular

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

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression toBigDecimal (    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 size (    Expression collection ) Create an expression that tests the size of a collection. Parameters: collection - expression Returns: size expression . Since: Jakarta Persistence (JPA) 1.0

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

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

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

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

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression greatest (    Expression x ) Create an aggregate expression for finding the greatest of the values (strings, dates, etc). Parameters: x - expression representing input value to greatest operation

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression least (    Expression x ) Create an aggregate expression for finding the least of the values (strings, dates, etc). Parameters: x - expression representing input value to least operation Returns: least expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression locate (    Expression x ,    String pattern ,    int from ) Create expression to locate the position of one string within another, returning position of first character

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression replace (    Expression x ,    String substring ,    String replacement ) Create an expression replacing every occurrence of a substring within a string. Parameters: x - string

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression locate (    Expression x ,    String pattern ) Create expression to locate ... . Parameters: x - expression for string to be searched pattern - string to be located Returns: expression

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression coalesce (    Expression x ,    Y y ) Create an expression that returns null ... - expression y - value Returns: coalesce expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Subquery select (    Expression expression ) Specify the item that is to be returned as the subquery result. Replaces the previously specified selection, if any. Parameters: expression - expression specifying

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression mod (    Integer x ,    Expression y ) Create an expression that returns the modulus (remainder under integer division) of its arguments. Parameters: x - value y - expression Returns: modulus. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder.Coalesce Coalesce value (    Expression value ) Add an argument to the coalesce expression . Parameters: value - expression Returns: coalesce expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sqrt (    Expression x ) Create an expression that returns the square root of its argument. Parameters: x - expression Returns: square root. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression exp (    Expression x ) Create an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument. Parameters: x - expression Returns: exponential. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression ln (    Expression x ) Create an expression that returns the natural logarithm of its argument. Parameters: x - expression Returns: natural logarithm. Since: Jakarta Persistence (JPA) 1.0

SimpleCase when (    C condition ,    Expression result ) Add a when/then clause to the case expression . Parameters: result - "then" result expression condition - "when" condition Returns: simple case expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sign (    Expression x ) Create an expression that returns the sign of its argument, that is, 1 ... . Parameters: x - expression Returns: sign. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression neg (    Expression x ) Create an expression that returns the arithmetic negation of its argument. Parameters: x - expression Returns: arithmetic negation. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression abs (    Expression x ) Create an expression that returns the absolute value of its argument. Parameters: x - expression Returns: absolute value. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sum (    N x ,    Expression y ) Create an expression that returns the sum of its arguments. Parameters: x - value y - expression Returns: sum. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression prod (    Expression x ,    N y ) Create an expression that returns the product of its arguments. Parameters: x - expression y - value Returns: product. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression prod (    N x ,    Expression y ) Create an expression that returns the product of its arguments. Parameters: x - value y - expression Returns: product. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression ceiling (    Expression x ) Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument. Parameters: x - expression Returns: ceiling. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression floor (    Expression x ) Create an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument. Parameters: x - expression Returns: floor. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sum (    Expression x ,    N y ) Create an expression that returns the sum of its arguments. Parameters: x - expression y - value Returns: sum. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression quot (    Expression x ,    Number y ) Create an expression that returns the quotient of its arguments. Parameters: x - expression y - value Returns: quotient. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression quot (    Number x ,    Expression y ) Create an expression that returns the quotient of its arguments. Parameters: x - value y - expression Returns: quotient. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression mod (    Expression x ,    Integer y ) Create an expression that returns the modulus (remainder under integer division) of its arguments. Parameters: x - expression y - value Returns: modulus. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression diff (    Expression x ,    N y ) Create an expression that returns the difference between its arguments. Parameters: x - expression y - value Returns: difference. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression diff (    N x ,    Expression y ) Create an expression that returns the difference between its arguments. Parameters: x - value y - expression Returns: difference. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder In in (    Expression expression ) Create predicate to test whether given expression is contained in a list of values. Parameters: expression - to be tested against list of values Returns: in predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression extract (    TemporalField field ,    Expression temporal ) Create an expression ... - a temporal field type temporal - a date, time, or datetime Returns: expression for the value of the extracted field. Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression function (    String name ,    Class type ,    Expression ... args ) Create an expression for the execution of a database function. Parameters: name - function name args

;  Expression restriction ) Modify the subquery to restrict the result according to the specified boolean expression . Replaces the previously added restriction(s), if any. This method ... compound boolean expression Returns: the modified subquery. Since: Jakarta Persistence (JPA) 1.0

where (    Expression restriction ) Modify the query to restrict the query results according to the specified boolean expression . Replaces the previously added restriction(s), if any. Parameters: restriction - a simple or compound boolean expression Returns: the modified query. Since: Jakarta Persistence (JPA) 1.0

(    Expression x ,    String pattern ,    char escapeChar ) Create a predicate for testing whether the expression does not satisfy the given pattern. Parameters: x - string expression pattern - string escapeChar - escape character Returns: not-like predicate. Since: Jakarta Persistence (JPA) 1.0

(    Expression x ,    String pattern ,    char escapeChar ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string escapeChar - escape character Returns: like predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate notLike (    Expression x ,    String pattern ) Create a predicate for testing whether the expression does not satisfy the given pattern. Parameters: x - string expression pattern

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder.Case Case when (    Expression condition ,    R result ) Add a when/then clause to the case expression . Parameters: result - "then" result value condition - "when" condition Returns: general case expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression power (    Expression x ,    Number y ) Create an expression that returns the first argument raised to the power of its second argument. Parameters: x - base y - exponent Returns

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression round (    Expression x ,    Integer n ) Create an expression that returns the first argument rounded to the number of decimal places given by the second argument. Parameters: x - base n

SimpleCase when (    Expression condition ,    R result ) Add a when/then clause to the case expression . Parameters: result - "then" result value condition - "when" condition Returns: simple case expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate like (    Expression x ,    String pattern ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string Returns: like predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate isNull (    Expression x ) Create a predicate to test whether the expression is null. Parameters: x - expression Returns: is-null predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate isNotNull (    Expression x ) Create a predicate to test whether the expression is not null. Parameters: x - expression Returns: is-not-null predicate. Since: Jakarta Persistence (JPA) 1.0