Purpose: Define an object-level representation of a database query where clause.
Description: An expression is a tree-like structure that defines the selection criteria for a query against objects in the database. The expression has the advantage over SQL by being at the object-level, i.e. the object model attributes and relationships can be used to be query on instead of the database field names. Because it is an object, not a string the expression has the advantage that is can be easily manipulated through code to easily build complex selection criterias.
Responsibilities:
| Modifier and Type | Field and Description |
|---|---|
| protected transient DatabaseTable | |
| protected int | hashCode
PERF: Cache the hashCode. |
| protected transient DatabaseTable | lastTable
Temporary values for table aliasing |
| protected boolean | |
| pack-priv static final long | serialVersionUID
Required for serialization compatibility. |
| public static boolean | shouldUseUpperCaseForIgnoreCase
Use the upper() function for case insensitive expression operations (default). |
| Access | Constructor and Description |
|---|---|
| protected |
| Modifier and Type | Method and Description |
|---|---|
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public DatabaseTable | |
| public Expression | |
| public Expression | all(char[] theChars)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | all(double[] theDoubles)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | all(float[] theFloats)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | all(int[] theInts)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | all(long[] theLongs)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | |
| public Expression | all(short[] theShorts)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | all(boolean[] theBooleans)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | Returns: a notExists subQuery expressionmust have its own builder, as it will become the
separate selection criteria of a subQuery. criteria)PUBLIC: Returns an expression equivalent to all of |
| public Expression | and(Expression theExpression)
PUBLIC: Return an expression that is the boolean logical combination of both expressions. |
| public Expression | |
| public Expression | any(char[] theChars)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | any(double[] theDoubles)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | any(float[] theFloats)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | any(int[] theInts)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | any(long[] theLongs)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | |
| public Expression | any(short[] theShorts)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | any(boolean[] theBooleans)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | anyOfAllowingNone(String attributeName)
ADVANCED: Return an expression representing traversal of a 1:many or many:many relationship. |
| public Expression | anyOfAllowingNone(String attributeName, boolean
indicates whether a new expression should be created. shouldJoinBeIndependent)ADVANCED: Return an expression representing traversal of a 1:many or many:many relationship. |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | Returns: thisA read only data object used to represent a past time. pastTime)Sets all tables represented by this expression to be queried as of a past time. |
| protected void | assignAlias(String name, DatabaseTable tableOrExpression)
INTERNAL: Alias a particular table within this node |
| public int | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | caseConditionStatement(Map<Expression, Object>
java.util.Map
A Map containing the items to be processed.
Keys represent the items to match coming from the query.
Values represent what a key will be changed to. caseConditions, Object java.lang.Object the default value that will be used if none of the keys in the
Map match defaultItem)PUBLIC: Function Convert values returned by the query to values given in the caseConditions Map. |
| public ArgumentListFunctionExpression | caseConditionStatement()
INTERNAL: Creates an ArgumentListFunctionExpression that is capable of creating a case statement of the form:
|
| public Expression | caseStatement(Map<K, V>
java.util.Map
A Map containing the items to be processed.
Keys represent the items to match coming from the query.
Values represent what a key will be changed to. caseItems, Object java.lang.String the default value that will be used if none of the keys in the
hashtable match defaultItem)PUBLIC: Function Convert values returned by the query to values given in the caseItems Map. |
| public ArgumentListFunctionExpression | caseStatement()
INTERNAL: Creates an ArgumentListFunctionExpression that is capable of creating a case statement of the form:
|
| public Expression | |
| public Object | clone()
Overrides java. |
| public Expression | cloneUsing(Expression newBase)
INTERNAL: This expression is built on a different base than the one we want. |
| public ArgumentListFunctionExpression | coalesce(Collection<E>
java.util.Collection
A Collection containing the items to check if null expressions)PUBLIC: Function Return null if all arguments are null and the first non-null argument otherwise The equivalent of the COALESCE SQL function Example:
|
| public ArgumentListFunctionExpression | |
| public int | |
| public Expression | |
| public Expression | containsAllKeyWords(String spaceSeparatedKeyWords)
PUBLIC: Return an expression that performs a key word search. |
| public Expression | containsAnyKeyWords(String spaceSeparatedKeyWords)
PUBLIC: Return an expression that performs a key word search. |
| public Expression | containsSubstring(String theValue)
PUBLIC: Return an expression that compares if the receivers value contains the substring. |
| public Expression | containsSubstring(Expression expression)
PUBLIC: Return an expression that compares if the receivers value contains the substring. |
| public Expression | containsSubstringIgnoringCase(String theValue)
PUBLIC: Return an expression that compares if the receivers value contains the substring, ignoring case. |
| public Expression | containsSubstringIgnoringCase(Expression expression)
PUBLIC: Return an expression that compares if the receivers value contains the substring, ignoring case. |
| protected void | |
| public Expression | convertToUseOuterJoin()
INTERNAL: Modify this expression to use outer joins wherever there are equality operations between two field nodes. |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | currentDateDate()
PUBLIC: This gives access to the current date only on the database through expression. |
| public Expression | |
| public Expression | currentTimeStamp()
PUBLIC: This gives access to the current timestamp on the database through expression. |
| public Expression | dateDifference(String datePart, Date date)
PUBLIC: Function, Return the difference between the queried part of a date(i.e. years, days etc.) and same part of the given date. |
| public Expression | dateDifference(String datePart, Expression comparisonExpression)
PUBLIC: Function, Return the difference between the queried part of a date(i.e. years, days etc.) and same part of the given date. |
| public Expression | |
| public Expression | |
| public Expression | dateToString()
PUBLIC: Function, returns the date converted to the string value in the default database format. |
| public Expression | decode(Map<K, V>
java.util.Map
a Map containing the items to be decoded. Keys represent
the items to match coming from the query. Values represent what
a key will be changed to. decodeableItems, String the default value that will be used if none of the keys in the
Map match defaultItem)PUBLIC: Function Convert values returned by the query to values given in the decodeableItems Map. |
| public Expression | |
| public String | |
| public Expression | difference(String expression)
PUBLIC: Function return a value which indicates how much difference there is between two expressions. |
| public Expression | |
| public boolean | doesConform(Object object, AbstractSession session, AbstractRecord translationRow, int valueHolderPolicy)
INTERNAL: Check if the object conforms to the expression in memory. |
| public boolean | doesConform(Object object, AbstractSession session, AbstractRecord translationRow, int valueHolderPolicy, boolean
true if object possibly not a clone, but is being
conformed against the unit of work cache; if object is not in the UOW cache
but some of its attributes are, use the registered versions of
object's attributes for the purposes of this method. objectIsUnregistered)INTERNAL: New parameter added to doesConform for feature 2612601 |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | equal(Expression theValue)
Returns an expression that compares if the receiver's value is equal to the other value. |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | equalOuterJoin(Expression theValue)
INTERNAL: Return an expression representing an outer join comparison |
| public boolean | equals(Object
the reference object with which to compare. expression)Overrides java. |
| public Expression | equalsIgnoreCase(String theValue)
PUBLIC: Return an expression that compares if the receiver's value is equal to the other value, ignoring case. |
| public Expression | equalsIgnoreCase(Expression theValue)
PUBLIC: Return an expression that compares if the receiver's value is equal to the other value, ignoring case. |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | existsNode(String
Xpath expression xpath)PUBLIC: XMLType Function, gets the number of nodes returned by the given xpath expression returns 0 if there are none |
| public Expression | |
| public boolean | extractFields(boolean requireExactMatch, boolean primaryKey, ClassDescriptor descriptor, List<DatabaseField> searchFields, Set<DatabaseField> foundFields)
INTERNAL: Return if the expression is not a valid primary key expression and add all primary key fields to the set. |
| public boolean | extractPrimaryKeyValues(boolean requireExactMatch, ClassDescriptor descriptor, AbstractRecord primaryKeyRow, AbstractRecord translationRow)
INTERNAL: Extract the primary key from the expression into the row. |
| public Expression | extractValue(String
XPath expression xpath)PUBLIC: XMLType Function, extracts a value from an XMLType field |
| public boolean | extractValues(boolean primaryKeyOnly, boolean requireExactMatch, ClassDescriptor descriptor, AbstractRecord primaryKeyRow, AbstractRecord translationRow)
INTERNAL: Extract the primary key from the expression into the row. |
| public Expression | extractXml(String
XPath expression representing the node to be returned xpath)PUBLIC: XMLType Function, extracts a secton of XML from a larget XML document |
| public static Expression | |
| public static Expression | |
| public static Expression | |
| public Expression | |
| public Expression | |
| public Expression | getAlias(Expression subSelect)
ADVANCED: Return an expression representing a sub-select in the from clause. |
| public Expression | getAllowingNull(String attributeName)
ADVANCED: Return an expression that wraps the attribute or query key name. |
| public AsOfClause | Returns: An immutable object representation of the past time.null if no clause set, AsOfClause.NO_CLAUSE if
clause explicitly set to null.Answers the past time the expression is explicitly as of. |
| public AsOfClause | getAsOfClauseRecursively()
INTERNAL: For Flashback: If this expression is not already as of some timestamp gets the clause from the base expression. |
| public abstract ExpressionBuilder | getBuilder()
INTERNAL: Return the expression builder which is the ultimate base of this expression, or null if there isn't one (shouldn't happen if we start from a root) |
| public DatabaseField | |
| public Expression | |
| public Expression | getField(DatabaseField field)
ADVANCED: Return an expression representing a field in a data-level query. |
| public List | |
| public Object | getFieldValue(Object objectValue, AbstractSession session)
INTERNAL: Transform the object-level value into a database-level value |
| public Expression | |
| public Expression | getFunction(int selector, List<E> arguments)
ADVANCED: This can be used for accessing user defined functions that have arguments. |
| public Expression | |
| public Expression | getFunction(String functionName, Object argument)
ADVANCED: Return a user defined function accepting the argument. |
| public Expression | getFunctionWithArguments(String functionName, List<E> arguments)
ADVANCED: Return a user defined function accepting all of the arguments. |
| public ClassDescriptor | getLeafDescriptor(DatabaseQuery query, ClassDescriptor rootDescriptor, AbstractSession session)
INTERNAL: Lookup the descriptor for this item by traversing its expression recursively. |
| public DatabaseMapping | getLeafMapping(DatabaseQuery query, ClassDescriptor rootDescriptor, AbstractSession session)
INTERNAL: Lookup the mapping for this item by traversing its expression recursively. |
| public String | |
| public Expression | |
| public ExpressionOperator | |
| public static ExpressionOperator | |
| public List | |
| public Expression | getParameter(String parameterName, Object type)
INTERNAL: Return an expression representing a parameter with the given name and type |
| public Expression | getParameter(String parameterName)
ADVANCED: Return an expression representing a parameter with the given name. |
| public Expression | getParameter(DatabaseField field)
ADVANCED: Return an expression representing a parameter with the given name. |
| public Expression | getProperty(DatabaseField field)
ADVANCED: Return an expression representing a property with the given name. |
| public List | |
| public List | |
| public AbstractSession | |
| public Expression | |
| public Expression | |
| public Expression | getTable(DatabaseTable table)
ADVANCED: Return an expression representing a table in a data-level query. |
| public TableAliasLookup | |
| public Expression | greaterThan(byte theValue)
PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
| public Expression | greaterThan(char theChar)
PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
| public Expression | greaterThan(double theValue)
PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
| public Expression | greaterThan(float theValue)
PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
| public Expression | greaterThan(int theValue)
PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
| public Expression | greaterThan(long theValue)
PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
| public Expression | greaterThan(Object theValue)
PUBLIC: Return an expression that compares if the receiver's value is greater than the other value. |
| public Expression | |
| public Expression | greaterThan(short theValue)
PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
| public Expression | greaterThan(boolean theBoolean)
PUBLIC: Return an expression that compares if the receivers value is equal to the other value. |
| public Expression | greaterThanEqual(byte theValue)
PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
| public Expression | greaterThanEqual(char theChar)
PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
| public Expression | greaterThanEqual(double theValue)
PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
| public Expression | greaterThanEqual(float theValue)
PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
| public Expression | greaterThanEqual(int theValue)
PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
| public Expression | greaterThanEqual(long theValue)
PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
| public Expression | greaterThanEqual(Object theValue)
PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
| public Expression | greaterThanEqual(Expression theValue)
PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
| public Expression | greaterThanEqual(short theValue)
PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
| public Expression | greaterThanEqual(boolean theBoolean)
PUBLIC: Return an expression that compares if the receivers value is greater and equal to the other value. |
| public boolean | Returns: false fromasOf(null); hasAsOfClause().ADVANCED:
Answers true if |
| public boolean | hasBeenAliased()
INTERNAL: Answers if the database tables associated with this expression have been aliased. |
| public int | hashCode()
Overrides java. |
| public Expression | |
| public Expression | |
| public Expression | in(byte[] theBytes)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | in(char[] theChars)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | in(double[] theDoubles)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | in(float[] theFloats)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | in(int[] theInts)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | in(long[] theLongs)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | |
| public Expression | in(short[] theShorts)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | in(boolean[] theBooleans)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | in(Collection<E> theObjects)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public boolean | |
| public boolean | |
| public boolean | |
| public boolean | |
| public Expression | |
| public boolean | |
| public boolean | |
| public Expression | isFragment()
PUBLIC: XMLType Function - evaluates to 0 if the xml is a well formed document and 1 if the document is a fragment |
| public boolean | |
| public boolean | |
| public boolean | |
| public boolean | |
| public Expression | |
| public boolean | |
| public boolean | |
| public boolean | |
| public boolean | |
| public boolean | |
| public boolean | |
| public boolean | |
| public boolean | isValueExpression()
INTERNAL: Subclasses implement (isParameterExpression() || isConstantExpression()) |
| public void | |
| public Expression | join(Expression target, Expression onClause)
ADVANCED: Defines a join between the two objects based on the specified ON clause. |
| public Expression | |
| public Expression | leftJoin(Expression target, Expression onClause)
ADVANCED: Defines an outer join between the two objects based on the specified ON clause. |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | lessThan(byte theValue)
PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
| public Expression | lessThan(char theChar)
PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
| public Expression | lessThan(double theValue)
PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
| public Expression | lessThan(float theValue)
PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
| public Expression | lessThan(int theValue)
PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
| public Expression | lessThan(long theValue)
PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
| public Expression | |
| public Expression | |
| public Expression | lessThan(short theValue)
PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
| public Expression | lessThan(boolean theBoolean)
PUBLIC: Return an expression that compares if the receivers value is less than the other value. |
| public Expression | lessThanEqual(byte theValue)
PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
| public Expression | lessThanEqual(char theChar)
PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
| public Expression | lessThanEqual(double theValue)
PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
| public Expression | lessThanEqual(float theValue)
PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
| public Expression | lessThanEqual(int theValue)
PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
| public Expression | lessThanEqual(long theValue)
PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
| public Expression | lessThanEqual(Object theValue)
PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
| public Expression | lessThanEqual(Expression theValue)
PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
| public Expression | lessThanEqual(short theValue)
PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
| public Expression | lessThanEqual(boolean theBoolean)
PUBLIC: Return an expression that compares if the receivers value is less than and equal to the other value. |
| public Expression | |
| public Expression | |
| public Expression | like(Expression argument)
PUBLIC: Return an expression that compares if the receivers value is like other value. |
| public Expression | like(Expression value, Expression escapeSequence)
PUBLIC: Return an expression that compares if the receivers value is like other value. |
| public Expression | likeIgnoreCase(String theValue)
PUBLIC: Return an expression that compares if the receivers value is like the other value, ignoring case. |
| public Expression | likeIgnoreCase(Expression theValue)
PUBLIC: Return an expression that compares if the receivers value is like the other value, ignoring case. |
| public Expression | |
| public Expression | |
| public Expression | localDateTime()
PUBLIC: This gives access to the local date and time on the database through expression. |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | mapEntry()
PUBLIC: Return a Map.Entry containing the key and the value from a mapping that maps to a java.util.Map This expression can only be used as a return value in a ReportQuery and cannot be used as part of the WHERE clause in any query EclipseLink: eb.get("mapAttribute").mapEntry() |
| public Expression | mapKey()
PUBLIC: Return the key from a mapping that maps to a java.util.Map This expression can be used either in as a return value in a ReportQuery or in the WHERE clause in a query EclipseLink: eb.get("mapAttribute").mapKey() |
| public Expression | |
| public Expression | |
| public Expression | monthsBetween(Object otherDate)
PUBLIC: Function, returns the decimal number of months between the two dates. |
| public Expression | |
| public Expression | |
| public Expression | Returns: a notExists subQuery expressionmust have its own builder, as it will become the
separate selection criteria of a subQuery. criteria)PUBLIC: Returns an expression equivalent to none of |
| public Expression | |
| public Expression | |
| public Expression | notBetween(byte leftValue, byte rightValue)
PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
| public Expression | notBetween(char leftChar, char rightChar)
PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
| public Expression | notBetween(double leftValue, double rightValue)
PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
| public Expression | notBetween(float leftValue, float rightValue)
PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
| public Expression | notBetween(int leftValue, int rightValue)
PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
| public Expression | notBetween(long leftValue, long rightValue)
PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
| public Expression | notBetween(Object leftValue, Object rightValue)
PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
| public Expression | notBetween(Expression leftExpression, Expression rightExpression)
PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
| public Expression | notBetween(short leftValue, short rightValue)
PUBLIC: Return an expression that compares if the receivers value is not between two other values. |
| public Expression | |
| public Expression | notEqual(byte theValue)
PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
| public Expression | notEqual(char theChar)
PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
| public Expression | notEqual(double theValue)
PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
| public Expression | notEqual(float theValue)
PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
| public Expression | notEqual(int theValue)
PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
| public Expression | notEqual(long theValue)
PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
| public Expression | |
| public Expression | notEqual(Expression theValue)
PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
| public Expression | notEqual(short theValue)
PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
| public Expression | notEqual(boolean theBoolean)
PUBLIC: Return an expression that compares if the receivers value is not equal to the other value. |
| public Expression | |
| public Expression | notIn(byte[] theBytes)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | notIn(char[] theChars)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | notIn(double[] theDoubles)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | notIn(float[] theFloats)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | notIn(int[] theInts)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | notIn(long[] theLongs)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | |
| public Expression | |
| public Expression | notIn(short[] theShorts)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | notIn(boolean[] theBooleans)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | notIn(Collection<E> theObjects)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | |
| public Expression | |
| public Expression | notLike(Expression arguments)
PUBLIC: Return an expression that compares if the receivers value is not like the other value. |
| public Expression | |
| public Expression | notLike(Expression
string to compare value, Expression the escape character to use escapeSequence)PUBLIC: Return an expression that compares if the receivers value is not like the other value. |
| public Expression | notNull()
PUBLIC: Return an expression representing a comparison to null Example:
|
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | or(Expression theExpression)
PUBLIC: Return an expression that is the boolean logical combination of both expressions. |
| public Expression | |
| protected void | |
| public Expression | |
| public Expression | |
| public void | |
| public abstract void | |
| public abstract Expression | rebuildOn(Expression newBase)
INTERNAL: This expression is built on a different base than the one we want. |
| public Expression | |
| public Expression | |
| public Expression | regexp(Expression regexp)
PUBLIC: Return an expression that compares if the receivers value matches the regular expression. |
| protected Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| protected void | |
| public abstract void | resetPlaceHolderBuilder(ExpressionBuilder queryBuilder)
INTERNAL: Search the tree for any expressions (like SubSelectExpressions) that have been built using a builder that is not attached to the query. |
| public Expression | |
| public Expression | right(int characters)
PUBLIC: Function return a given number of characters starting at the right of a string. |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public boolean | selectIfOrderedBy()
PUBLIC: Return whether this expression should be included in the SELECT clause if it is used in an ORDER BY clause |
| public void | setLocalBase(Expression exp)
INTERNAL: Set the local base expression, ie the one on the other side of the operator Most types will ignore this, since they don't need it. |
| public void | setSelectIfOrderedBy(boolean selectIfOrderedBy)
PUBLIC: Set whether this expression should be included in the SELECT clause of a query that uses it in the ORDER BY clause. |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | some(char[] theChars)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | some(double[] theDoubles)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | some(float[] theFloats)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | some(int[] theInts)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | some(long[] theLongs)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | |
| public Expression | some(short[] theShorts)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | some(boolean[] theBooleans)
PUBLIC: Return an expression that checks if the receivers value is contained in the collection. |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | substring(int startPosition, int size)
PUBLIC: Function, returns the substring from the source string. |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | toChar()
PUBLIC: Return an expression that represents the receiver value converted to a character string. |
| public Expression | |
| public Expression | toCharacter()
PUBLIC: Function, returns the single character string with the ascii or character set value. |
| public Expression | |
| public Expression | toLowerCase()
PUBLIC: Return an expression that represents the receiver value converted to lower case. |
| public Expression | |
| public String | |
| public void | |
| public Expression | toUpperCase()
PUBLIC: Return an expression that represents the receiver value converted to upper case. |
| public Expression | toUppercaseCasedWords()
PUBLIC: Function, returns the string with the first letter of each word capitalized. |
| public Expression | |
| public Expression | treat(Class<?> castClass)
ADVANCED: Return an expression that allows you to treat its base as if it were a subclass of the class returned by the base This can only be called on an ExpressionBuilder, the result of expression.get(String), expression.getAllowingNull(String), the result of expression.anyOf("String") or the result of expression.anyOfAllowingNull("String") downcast uses Expression.type() internally to guarantee the results are of the specified class. |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | twist(Expression expression, Expression newBase)
INTERNAL: We are given an expression that comes from a different context than the one in which this was built, e.g. it is the selection criteria of a mapping, or the criteria on which multiple tables are joined in a descriptor. |
| public Expression | twistedForBaseAndContext(Expression newBase, Expression context, Expression oldBase)
INTERNAL: Rebuild myself against the base, with the values of parameters supplied by the context expression. |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public void | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Expression | |
| public Object | valueFromObject(Object object, AbstractSession session, AbstractRecord translationRow, int valueHolderPolicy, boolean
true if object possibly not a clone, but is being
conformed against the unit of work cache. isObjectUnregistered)INTERNAL: Return the value for in memory comparison. |
| public Object | valueFromObject(Object object, AbstractSession session, AbstractRecord translationRow, int valueHolderPolicy)
INTERNAL: Return the value for in memory comparison. |
| public Expression | |
| protected void | writeAlias(ExpressionSQLPrinter printer, DatabaseField field, SQLSelectStatement statement)
INTERNAL: Append the field's alias to the writer. |
| public void | writeDescriptionOn(BufferedWriter writer)
INTERNAL: Used to print a debug form of the expression tree. |
| protected void | writeField(ExpressionSQLPrinter printer, DatabaseField field, SQLSelectStatement statement)
INTERNAL: Append the field name to the writer. |
| public void | writeFields(ExpressionSQLPrinter printer, List<DatabaseField> newFields, SQLSelectStatement statement)
INTERNAL: called from SQLSelectStatement.writeFieldsFromExpression(...) |
| public void |