# Uses of Class
org.apache.torque.criteria.SqlEnum

Packages that use SqlEnum
Package
Description
org.apache.torque.criteria
This package contains Torque's Criteria classes.
org.apache.torque.sql
This package contains classes which are mainly used in the SQL generation process.

- ## Uses of SqlEnum in org.apache.torque.criteria

  Fields in org.apache.torque.criteria declared as SqlEnum
  Modifier and Type
  Field
  Description
  `static final SqlEnum`
  Criteria.`ALL`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`ALL`
  SQL Expression "ALL ".
  `static final SqlEnum`
  Criteria.`ALT_NOT_EQUAL`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`ALT_NOT_EQUAL`
  SQL Expression "!
  `static final SqlEnum`
  SqlEnum.`AS`
  SQL Expression " AS ".
  `static final SqlEnum`
  SqlEnum.`ASC`
  SQL Expression "ASC".
  `static final SqlEnum`
  Criteria.`CURRENT_DATE`
  "CURRENT_DATE" ANSI SQL function
  `static final SqlEnum`
  SqlEnum.`CURRENT_DATE`
  SQL Expression "CURRENT_DATE".
  `static final SqlEnum`
  Criteria.`CURRENT_TIME`
  "CURRENT_TIME" ANSI SQL function
  `static final SqlEnum`
  SqlEnum.`CURRENT_TIME`
  SQL Expression "CURRENT_TIME".
  `static final SqlEnum`
  Criteria.`CURRENT_TIMESTAMP`
  "CURRENT_TIMESTAMP" ANSI SQL function
  `static final SqlEnum`
  SqlEnum.`CURRENT_TIMESTAMP`
  SQL Expression "CURRENT_TIMESTAMP".
  `static final SqlEnum`
  SqlEnum.`DESC`
  SQL Expression "DESC".
  `static final SqlEnum`
  Criteria.`DISTINCT`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`DISTINCT`
  SQL Expression "DISTINCT ".
  `static final SqlEnum`
  Criteria.`EQUAL`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`EQUAL`
  SQL Expression "=".
  `static final SqlEnum`
  SqlEnum.`ESCAPE`
  SQL Expression " ESCAPE ".
  `static final SqlEnum`
  SqlEnum.`EXCEPT`
  SQL Expression " EXCEPT ".
  `static final SqlEnum`
  SqlEnum.`EXCEPT_ALL`
  SQL Expression " EXCEPT ALL ".
  `static final SqlEnum`
  Criteria.`GREATER_EQUAL`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`GREATER_EQUAL`
  SQL Expression ">=".
  `static final SqlEnum`
  Criteria.`GREATER_THAN`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`GREATER_THAN`
  SQL Expression ">".
  `static final SqlEnum`
  Criteria.`ILIKE`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`ILIKE`
  SQL Expression " ILIKE ".
  `static final SqlEnum`
  Criteria.`IN`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`IN`
  SQL Expression " IN ".
  `static final SqlEnum`
  SqlEnum.`INTERSECT`
  SQL Expression " INTERSECT ".
  `static final SqlEnum`
  SqlEnum.`INTERSECT_ALL`
  SQL Expression " INTERSECT ALL ".
  `static final SqlEnum`
  Criteria.`ISNOTNULL`
  "IS NOT NULL" null comparison
  `static final SqlEnum`
  SqlEnum.`ISNOTNULL`
  SQL Expression " IS NOT NULL".
  `static final SqlEnum`
  Criteria.`ISNULL`
  "IS NULL" null comparison
  `static final SqlEnum`
  SqlEnum.`ISNULL`
  SQL Expression " IS NULL".
  `static final SqlEnum`
  Criteria.`JOIN`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`JOIN`
  SQL Expression "JOIN".
  `static final SqlEnum`
  Criteria.`LESS_EQUAL`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`LESS_EQUAL`
  SQL Expression "<=".
  `static final SqlEnum`
  Criteria.`LESS_THAN`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`LESS_THAN`
  SQL Expression "<".
  `static final SqlEnum`
  Criteria.`LIKE`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`LIKE`
  SQL Expression " LIKE ".
  `static final SqlEnum`
  SqlEnum.`MINUS`
  SQL Expression " MINUS ".
  `static final SqlEnum`
  SqlEnum.`MINUS_ALL`
  SQL Expression " MINUS ALL ".
  `static final SqlEnum`
  Criteria.`NOT_EQUAL`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`NOT_EQUAL`
  SQL Expression "<>".
  `static final SqlEnum`
  Criteria.`NOT_ILIKE`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`NOT_ILIKE`
  SQL Expression " NOT ILIKE ".
  `static final SqlEnum`
  Criteria.`NOT_IN`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`NOT_IN`
  SQL Expression " NOT IN ".
  `static final SqlEnum`
  Criteria.`NOT_LIKE`
  Comparison type.
  `static final SqlEnum`
  SqlEnum.`NOT_LIKE`
  SQL Expression " NOT LIKE ".
  `static final SqlEnum`
  SqlEnum.`ON`
  SQL Expression " ON ".
  `static final SqlEnum`
  SqlEnum.`UNION`
  SQL Expression " UNION ".
  `static final SqlEnum`
  SqlEnum.`UNION_ALL`
  SQL Expression " UNION ALL ".
  Methods in org.apache.torque.criteria that return SqlEnum
  Modifier and Type
  Method
  Description
  `SqlEnum`
  Criterion.`getComparison()`
  Get the comparison.
  `SqlEnum`
  Criteria.`getSetOperator()`
  Returns the operator between the set operations.
  Methods in org.apache.torque.criteria with parameters of type SqlEnum
  Modifier and Type
  Method
  Description
  `Criteria`
  Criteria.`addJoin(Column left, Column right, SqlEnum comparison, JoinType joinType)`
  Adds a join to the criteria, E.g. to create the condition
  `Criteria`
  Criteria.`and(Object lValue, Object rValue, SqlEnum comparison)`
  "AND"s a new condition with the conditions in this Criteria.
  `Criteria`
  Criteria.`andDate(Object lValue, int year, int month, int day, SqlEnum comparison)`
  Convenience method to AND a new date comparison with the conditions in this Criteria.
  `PreparedStatementPartImpl`
  PreparedStatementPartImpl.`append(SqlEnum toAppend)`
  Appends a SqlEnum to this part.
  `protected void`
  Criteria.`appendSetOperation(Criteria other, SqlEnum setOperator)`
  Appends a set operation (union, except, intersect) to this Criteria.
  `Criteria`
  Criteria.`or(Object lValue, Object rValue, SqlEnum comparison)`
  "OR"s a new condition with the conditions in this Criteria.
  `Criteria`
  Criteria.`orDate(Object lValue, int year, int month, int day, SqlEnum comparison)`
  Convenience method to OR a new date comparison with the conditions in this Criteria.
  `Criteria`
  Criteria.`where(Object lValue, Object rValue, SqlEnum comparison)`
  "AND"s a new condition with the conditions in this Criteria.
  `Criteria`
  Criteria.`whereDate(Object lValue, int year, int month, int day, SqlEnum comparison)`
  Convenience method to AND a new date comparison with the conditions in this Criteria.
  Constructors in org.apache.torque.criteria with parameters of type SqlEnum
  Modifier
  Constructor
  Description
  ``
  `Criterion(Object lValue, Object rValue, SqlEnum comparison)`
  Create a new instance without verbatim sql.
  ``
  `Criterion(Object lValue, Object rValue, SqlEnum comparison, String sql, Object[] preparedStatementReplacements)`
  Create a new instance.
  ``
  `Criterion(Object lValue, SqlEnum comparison)`
  Create a new instance without verbatim sql, using a comparison operator without the need for a right value (like `ISNULL`, `ISNOTNULL`, etc.)
  ``
  `Join(Column leftColumn, Column rightColumn, SqlEnum comparison, JoinType joinType)`
  Constructor with the comparison operator.

- ## Uses of SqlEnum in org.apache.torque.sql

  Methods in org.apache.torque.sql that return SqlEnum
  Modifier and Type
  Method
  Description
  `SqlEnum`
  WhereClauseExpression.`getOperator()`
  Returns the value on the operator of the expression.
  `SqlEnum`
  OrderBy.`getOrder()`
  Returns the order to order by (ASC or DESC).
  Methods in org.apache.torque.sql with parameters of type SqlEnum
  Modifier and Type
  Method
  Description
  `void`
  WhereClauseExpression.`setOperator(SqlEnum operator)`
  Sets the value on the operator of the expression.
  Constructors in org.apache.torque.sql with parameters of type SqlEnum
  Modifier
  Constructor
  Description
  ``
  `OrderBy(Column column, SqlEnum order, boolean ignoreCase)`
  Constructor.
  ``
  `WhereClauseExpression(Object lValue, SqlEnum operator, Object rValue, String sql, Object[] preparedStatementReplacements)`
  Constructor.