## 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 SqlEnum` | Criteria.`ALL` | Comparison type.
    `static SqlEnum` | SqlEnum.`ALL` | SQL Expression "ALL ".
    `static SqlEnum` | Criteria.`ALT_NOT_EQUAL` | Comparison type.
    `static SqlEnum` | SqlEnum.`ALT_NOT_EQUAL` | SQL Expression "!
    `static SqlEnum` | SqlEnum.`AS` | SQL Expression " AS ".
    `static SqlEnum` | SqlEnum.`ASC` | SQL Expression "ASC".
    `static SqlEnum` | Criteria.`CURRENT_DATE` | "CURRENT_DATE" ANSI SQL function
    `static SqlEnum` | SqlEnum.`CURRENT_DATE` | SQL Expression "CURRENT_DATE".
    `static SqlEnum` | Criteria.`CURRENT_TIME` | "CURRENT_TIME" ANSI SQL function
    `static SqlEnum` | SqlEnum.`CURRENT_TIME` | SQL Expression "CURRENT_TIME".
    `static SqlEnum` | Criteria.`CURRENT_TIMESTAMP` | "CURRENT_TIMESTAMP" ANSI SQL function
    `static SqlEnum` | SqlEnum.`CURRENT_TIMESTAMP` | SQL Expression "CURRENT_TIMESTAMP".
    `static SqlEnum` | SqlEnum.`DESC` | SQL Expression "DESC".
    `static SqlEnum` | Criteria.`DISTINCT` | Comparison type.
    `static SqlEnum` | SqlEnum.`DISTINCT` | SQL Expression "DISTINCT ".
    `static SqlEnum` | Criteria.`EQUAL` | Comparison type.
    `static SqlEnum` | SqlEnum.`EQUAL` | SQL Expression "=".
    `static SqlEnum` | SqlEnum.`ESCAPE` | SQL Expression " ESCAPE ".
    `static SqlEnum` | SqlEnum.`EXCEPT` | SQL Expression " EXCEPT ".
    `static SqlEnum` | SqlEnum.`EXCEPT_ALL` | SQL Expression " EXCEPT ALL ".
    `static SqlEnum` | Criteria.`GREATER_EQUAL` | Comparison type.
    `static SqlEnum` | SqlEnum.`GREATER_EQUAL` | SQL Expression ">=".
    `static SqlEnum` | Criteria.`GREATER_THAN` | Comparison type.
    `static SqlEnum` | SqlEnum.`GREATER_THAN` | SQL Expression ">".
    `static SqlEnum` | Criteria.`ILIKE` | Comparison type.
    `static SqlEnum` | SqlEnum.`ILIKE` | SQL Expression " ILIKE ".
    `static SqlEnum` | Criteria.`IN` | Comparison type.
    `static SqlEnum` | SqlEnum.`IN` | SQL Expression " IN ".
    `static SqlEnum` | SqlEnum.`INTERSECT` | SQL Expression " INTERSECT ".
    `static SqlEnum` | SqlEnum.`INTERSECT_ALL` | SQL Expression " INTERSECT ALL ".
    `static SqlEnum` | Criteria.`ISNOTNULL` | "IS NOT NULL" null comparison
    `static SqlEnum` | SqlEnum.`ISNOTNULL` | SQL Expression " IS NOT NULL".
    `static SqlEnum` | Criteria.`ISNULL` | "IS NULL" null comparison
    `static SqlEnum` | SqlEnum.`ISNULL` | SQL Expression " IS NULL".
    `static SqlEnum` | Criteria.`JOIN` | Comparison type.
    `static SqlEnum` | SqlEnum.`JOIN` | SQL Expression "JOIN".
    `static SqlEnum` | Criteria.`LESS_EQUAL` | Comparison type.
    `static SqlEnum` | SqlEnum.`LESS_EQUAL` | SQL Expression "<=".
    `static SqlEnum` | Criteria.`LESS_THAN` | Comparison type.
    `static SqlEnum` | SqlEnum.`LESS_THAN` | SQL Expression "<".
    `static SqlEnum` | Criteria.`LIKE` | Comparison type.
    `static SqlEnum` | SqlEnum.`LIKE` | SQL Expression " LIKE ".
    `static SqlEnum` | SqlEnum.`MINUS` | SQL Expression " MINUS ".
    `static SqlEnum` | SqlEnum.`MINUS_ALL` | SQL Expression " MINUS ALL ".
    `static SqlEnum` | Criteria.`NOT_EQUAL` | Comparison type.
    `static SqlEnum` | SqlEnum.`NOT_EQUAL` | SQL Expression "<>".
    `static SqlEnum` | Criteria.`NOT_ILIKE` | Comparison type.
    `static SqlEnum` | SqlEnum.`NOT_ILIKE` | SQL Expression " NOT ILIKE ".
    `static SqlEnum` | Criteria.`NOT_IN` | Comparison type.
    `static SqlEnum` | SqlEnum.`NOT_IN` | SQL Expression " NOT IN ".
    `static SqlEnum` | Criteria.`NOT_LIKE` | Comparison type.
    `static SqlEnum` | SqlEnum.`NOT_LIKE` | SQL Expression " NOT LIKE ".
    `static SqlEnum` | SqlEnum.`ON` | SQL Expression " ON ".
    `static SqlEnum` | SqlEnum.`UNION` | SQL Expression " UNION ".
    `static 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
    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.
    `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
    Constructor | Description
    --- | ---
    `OrderBy​(Column column, SqlEnum order, boolean ignoreCase)` | Constructor.
    `WhereClauseExpression​(Object lValue, SqlEnum operator, Object rValue, String sql, Object[] preparedStatementReplacements)` | Constructor.