Uses of Class
org.apache.torque.criteria.Criteria

Packages that use Criteria

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.
org.apache.torque.util	Misc.

Uses of Criteria in org.apache.torque.criteria

Methods in org.apache.torque.criteria that return Criteria

Criteria	Criteria.addAscendingOrderByColumn(Column column) Adds an order by clause, explicitly specifying ascending.
Criteria	Criteria.addAscendingOrderByColumn(Column column, boolean ignoreCase) Add an order by clause, explicitly specifying ascending.
Criteria	Criteria.addAsColumn(String name, Column clause) Add an AS clause to the select columns.
Criteria	Criteria.addDescendingOrderByColumn(Column column) Add order by column name, explicitly specifying descending.
Criteria	Criteria.addDescendingOrderByColumn(Column column, boolean ignoreCase) Add order by column name, explicitly specifying descending.
Criteria	Criteria.addFrom(FromElement fromElement) Adds a new Element to the from clause.
Criteria	Criteria.addFrom(String tableName) Adds a table to the from clause, not using a joinType or joinCondition.
Criteria	Criteria.addGroupByColumn(Column groupBy) Add a group by clause.
Criteria	Criteria.addHaving(Criterion having) This method adds a prepared Criterion object to the Criteria as a having clause.
Criteria	Criteria.addJoin(Column left, Column right) Adds a join to the criteria, E.g.
Criteria	Criteria.addJoin(Column left, Column right, JoinType joinType) Adds a join to the criteria, E.g.
Criteria	Criteria.addJoin(Column left, Column right, SqlEnum comparison, JoinType joinType) Adds a join to the criteria, E.g.
Criteria	Criteria.addJoin(PreparedStatementPart leftTable, PreparedStatementPart rightTable, Criterion joinCondition, JoinType joinType) Adds a join to the criteria, E.g.
Criteria	Criteria.addJoin(String leftTable, String rightTable, Criterion joinCondition, JoinType joinType) Adds a join to the criteria, E.g.
Criteria	Criteria.addSelectColumn(Column column) Adds a select column to the Criteria.
Criteria	Criteria.and(Criterion criterion) "AND"s Criterion object with the conditions in this Criteria.
Criteria	Criteria.and(Object lValue, Object rValue) "AND"s a new condition with the conditions in this Criteria.
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) Convenience method to AND a new date comparison 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.
Criteria	Criteria.andIn(Object lValue, Collection<?> rValues) Convenience method to AND a "in" comparison with the conditions in this Criteria.
Criteria	Criteria.andIn(Object lValue, Object[] rValues) Convenience method to AND a "in" comparison with the conditions in this Criteria.
Criteria	Criteria.andNotIn(Object lValue, Collection<?> rValues) Convenience method to AND a "not in" comparison with the conditions in this Criteria.
Criteria	Criteria.andNotIn(Object lValue, Object[] rValues) Convenience method to AND a "not in" comparison with the conditions in this Criteria.
Criteria	Criteria.andVerbatimSql(String sql, Object[] replacements) Ands a verbatim sql condition to this Criteria.
Criteria	Criteria.andVerbatimSql(String sql, Object[] replacements, Column toAddToFromClause1, Column toAddToFromClause2) ANDs a verbatim sql condition to this Criteria.
Criteria	Criteria.getSubselectForAlias(String alias) Returns the subselect associated with an alias.
Criteria	Criteria.or(Criterion criterion) "OR"s a Criterion object with the conditions in this Criteria.
Criteria	Criteria.or(Object lValue, Object rValue) "OR"s a new condition with the conditions in 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) Convenience method to OR a new date comparison 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.orIn(Object lValue, Collection<?> rValues) Convenience method to OR a "in" comparison with the conditions in this Criteria.
Criteria	Criteria.orIn(Object lValue, Object[] rValues) Convenience method to OR a "in" comparison with the conditions in this Criteria.
Criteria	Criteria.orNotIn(Object lValue, Collection<?> rValues) Convenience method to OR a "not in" comparison with the conditions in this Criteria.
Criteria	Criteria.orNotIn(Object lValue, Object[] rValues) Convenience method to OR a "not in" comparison with the conditions in this Criteria.
Criteria	Criteria.orVerbatimSql(String sql, Object[] replacements) ORs a verbatim sql condition to this Criteria.
Criteria	Criteria.orVerbatimSql(String sql, Object[] replacements, Column toAddToFromClause1, Column toAddToFromClause2) ORs a verbatim sql condition to this Criteria.
Criteria	Criteria.setIgnoreCase(boolean ignoreCase) Sets whether case should be ignored in where clauses and order by whenever String columns are encountered.
Criteria	Criteria.setLimit(int limit) Set a limit for the query
Criteria	Criteria.setOffset(long offset) Set the offset.
Criteria	Criteria.setSingleRecord(boolean b) Switch the check on or off that a query returns exactly one record.
Criteria	Criteria.where(Criterion criterion) "AND"s Criterion object with the conditions in this Criteria.
Criteria	Criteria.where(Object lValue, Object rValue) "AND"s a new condition 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) Convenience method to AND a new date comparison 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.
Criteria	Criteria.whereIn(Object lValue, Collection<?> rValues) Convenience method to AND a "in" comparison with the conditions in this Criteria.
Criteria	Criteria.whereIn(Object lValue, Object[] rValues) Convenience method to AND a "in" comparison with the conditions in this Criteria.
Criteria	Criteria.whereNotIn(Object lValue, Collection<?> rValues) Convenience method to AND a "not in" comparison with the conditions in this Criteria.
Criteria	Criteria.whereNotIn(Object lValue, Object[] rValues) Convenience method to AND a "not in" comparison with the conditions in this Criteria.
Criteria	Criteria.whereVerbatimSql(String sql, Object[] replacements) Convenience method to AND a verbatim sql condition to this Criteria.
Criteria	Criteria.whereVerbatimSql(String sql, Object[] replacements, Column toAddToFromClause1, Column toAddToFromClause2) Convenience method to AND a verbatim sql condition to this Criteria.

Methods in org.apache.torque.criteria with parameters of type Criteria

void	Criteria.addAlias(String alias, Criteria subselect) Allows one to specify an alias for a subselect.

Uses of Criteria in org.apache.torque.sql

Methods in org.apache.torque.sql with parameters of type Criteria

static Query	SqlBuilder.buildQuery(Criteria crit) Builds a Query from a criteria.
static String	SqlBuilder.guessFullTableFromCriteria(Criteria criteria) Guesses a table name from a criteria by inspecting the first column in the criteria.

Uses of Criteria in org.apache.torque.util

Methods in org.apache.torque.util that return Criteria

Criteria

SummaryHelper.buildCriteria(Criteria c) Builds the criteria to use in summarizing the information.

Methods in org.apache.torque.util with parameters of type Criteria

void	BasePeerImpl.addSelectColumns(Criteria criteria) Add all the columns needed to create a new object.
Criteria	SummaryHelper.buildCriteria(Criteria c) Builds the criteria to use in summarizing the information.
void	BasePeerImpl.correctBooleans(Criteria criteria) Checks all columns in the criteria to see whether booleanchar and booleanint columns are queried with a boolean.
static void	BasePeer.correctBooleans(Criteria criteria) Deprecated. Checks all columns in the criteria to see whether booleanchar and booleanint columns are queried with a boolean.
int	CountHelper.count(Criteria c) The COUNT function returns the number of rows in a query.
int	CountHelper.count(Criteria c, Column column) Returns the number of rows in a query.
int	CountHelper.count(Criteria c, Connection conn) The COUNT function returns the number of rows in a query.
int	CountHelper.count(Criteria c, Connection conn, Column column) Returns the number of rows in a query.
int	CountHelper.count(Criteria c, Connection conn, String columnName, TableMap tableMap) Returns the number of rows in a query.
int	CountHelper.count(Criteria c, String columnName) Returns the number of rows in a query.
int	BasePeerImpl.doDelete(Criteria criteria) Deletes rows from a database table.
static int	BasePeer.doDelete(Criteria criteria) Deprecated. This method causes unexpected results when joins are used. Please use doDelete( org.apache.torque.criteria.Criteria, TableMap). This method will be removed in a future version of Torque.
int	BasePeerImpl.doDelete(Criteria criteria, Connection connection) Deletes rows from a table.
static int	BasePeer.doDelete(Criteria criteria, Connection con) Deprecated. This method causes unexpected results when joins are used. Please use doDelete(org.apache.torque.criteria.Criteria, TableMap, Connection). This method will be removed in a future version of Torque.
List<T>	BasePeerImpl.doSelect(Criteria criteria) Selects objects from a database.
List<T>	BasePeerImpl.doSelect(Criteria criteria, Connection connection) Selects objects from a database within a transaction.
static <T> List<T>	BasePeer.doSelect(Criteria criteria, RecordMapper<T> mapper) Deprecated. Selects rows from a database an maps them to objects.
static <T> List<T>	BasePeer.doSelect(Criteria criteria, RecordMapper<T> mapper, Connection connection) Deprecated. Selects rows from a database an maps them to objects.
<TT> List<TT>	BasePeerImpl.doSelect(Criteria criteria, RecordMapper<TT> mapper) Selects rows from a database an maps them to objects.
<TT> List<TT>	BasePeerImpl.doSelect(Criteria criteria, RecordMapper<TT> mapper, Connection connection) Performs a SQL select using a PreparedStatement.
T	BasePeerImpl.doSelectSingleRecord(Criteria criteria) Selects at most one object from a database.
T	BasePeerImpl.doSelectSingleRecord(Criteria criteria, Connection connection) Selects at most one object from a database within a transaction.
static <T> T	BasePeer.doSelectSingleRecord(Criteria criteria, RecordMapper<T> mapper) Deprecated. Selects at most a single row from a database an maps them to objects.
static <T> T	BasePeer.doSelectSingleRecord(Criteria criteria, RecordMapper<T> mapper, Connection connection) Deprecated. Selects at most a single row from a database an maps them to objects.
<TT> TT	BasePeerImpl.doSelectSingleRecord(Criteria criteria, RecordMapper<TT> mapper) Selects at most a single row from a database an maps them to objects.
<TT> TT	BasePeerImpl.doSelectSingleRecord(Criteria criteria, RecordMapper<TT> mapper, Connection connection) Selects at most a single row from a database an maps them to objects.
int	BasePeerImpl.doUpdate(Criteria selectCriteria, ColumnValues updateValues) Executes an update against the database.
static int	BasePeer.doUpdate(Criteria selectCriteria, ColumnValues updateValues) Deprecated. Executes an update against the database.
int	BasePeerImpl.doUpdate(Criteria criteria, ColumnValues updateValues, Connection connection) Executes an update against the database.
static int	BasePeer.doUpdate(Criteria criteria, ColumnValues updateValues, Connection connection) Deprecated. Executes an update against the database.
protected void	BasePeerImpl.setDbName(Criteria crit) Sets the database name in the passed criteria to the table's default, if it is not already set.
List<ListOrderedMapCI>	SummaryHelper.summarize(Criteria crit) Return a list of ListOrderedMapCI objects with the results of the summary query.
List<ListOrderedMapCI>	SummaryHelper.summarize(Criteria crit, Connection conn) Return a list of OrderedMap objects with the results of the summary query.
List<ListOrderedMapCI>	SummaryHelper.summarize(Criteria crit, List<Class<?>> resultTypes) Return a list of ListOrderedMapCI objects with the results of the summary query.
List<ListOrderedMapCI>	SummaryHelper.summarize(Criteria crit, List<Class<?>> resultTypes, Connection conn) Return a list of ListOrderedMapCI objects with the results of the summary query.