Adds a new order by condition.
Parameters: vi - the order by value (column) throws: com.flexive.sqlParser.SqlParserException - if the column cannot be used for ordering because it is not selected
Removes empty braces and handles conditions that are always false or true.
Also checks if all aliases are defined.
throws: SqlParserException - if the function fails
Returns a empty array if the filter is not set, or the id's of all briefcases to search in.
a empty array if the filter is not set, or the id's of all briefcases to search in.
Compute a cache key for the statement.
Statements with the same cache key will produce the same resultset.
the cacheKey. throws: SqlParserException - if the cache key could not be computed
Returns the selected value matching the given alias, or null if no match can be found.
If a alias is used more than one time the first match will be returned.
Parameters: alias - the alias to look for the matching selected value, or null
Returns the statements type.
TYPE.FILTER: there are conditions
TYPE.EMPTY: the statement will not deliver any results
TYPE.ALL: the statements will deliver all data from the selected sources (no filter set)
the statements type