Uses of Class
org.apache.cayenne.query.ColumnSelect

Packages that use ColumnSelect

Package	Description
org.apache.cayenne.query	Defines standard queries supported by Cayenne and extension mechanism to create custom queries.

Uses of ColumnSelect in org.apache.cayenne.query

Methods in org.apache.cayenne.query that return ColumnSelect

Modifier and Type	Method and Description
ColumnSelect<T>	ColumnSelect.and(Collection<Expression> expressions) AND's provided expressions to the existing WHERE or HAVING clause expression.
ColumnSelect<T>	ColumnSelect.and(Expression... expressions) AND's provided expressions to the existing WHERE clause expression.
ColumnSelect<Object[]>	ColumnSelect.avg(Property<?> property) Select average value of property
<E> ColumnSelect<E>	ObjectSelect.avg(Property<E> property) Select average value of property
ColumnSelect<T>	ColumnSelect.cacheGroup(String cacheGroup)
ColumnSelect<T>	ColumnSelect.cacheStrategy(QueryCacheStrategy strategy)
ColumnSelect<T>	ColumnSelect.cacheStrategy(QueryCacheStrategy strategy, String cacheGroup)
<E> ColumnSelect<E>	ObjectSelect.column(Property<E> property) Select one specific property.
protected <E> ColumnSelect<E>	ColumnSelect.column(Property<E> property)
static ColumnSelect<Object[]>	ObjectSelect.columnQuery(Class<?> entityType, Property<?> firstColumn, Property<?>... otherColumns) Creates a ColumnSelect that will fetch multiple columns of a given ObjEntity
static <E> ColumnSelect<E>	ObjectSelect.columnQuery(Class<?> entityType, Property<E> column) Creates a ColumnSelect that will fetch single property that can be resolved against a given ObjEntity class.
ColumnSelect<Object[]>	ColumnSelect.columns(Collection<Property<?>> properties) Add properties to select.
ColumnSelect<Object[]>	ObjectSelect.columns(Property<?> firstProperty, Property<?>... properties) Select only specific properties.
ColumnSelect<Object[]>	ColumnSelect.columns(Property<?> firstProperty, Property<?>... otherProperties) Add properties to select.
ColumnSelect<Long>	ObjectSelect.count() Select COUNT(*)
ColumnSelect<Object[]>	ColumnSelect.count() Shortcut for columns(Property, Property[]) columns}(Property.COUNT)
ColumnSelect<Long>	ObjectSelect.count(Property<?> property) Select COUNT(property)
ColumnSelect<Object[]>	ColumnSelect.count(Property<?> property) Select COUNT(property)
ColumnSelect<T>	ColumnSelect.dbEntityName(String dbEntityName) Sets the DbEntity name to fetch without changing the return type of the query.
ColumnSelect<T>	ColumnSelect.distinct() Explicitly request distinct in query.
ColumnSelect<T>	ColumnSelect.entityName(String entityName) Sets the ObjEntity name to fetch without changing the return type of the query.
ColumnSelect<T>	ColumnSelect.entityType(Class<?> entityType) Sets the type of the entity to fetch without changing the return type of the query.
ColumnSelect<T>	ColumnSelect.having(Expression expression) Appends a having qualifier expression of this query.
ColumnSelect<T>	ColumnSelect.having(String expressionString, Object... parameters) Appends a having qualifier expression of this query, using provided expression String and an array of position parameters.
ColumnSelect<T>	ColumnSelect.limit(int fetchLimit) Resets query fetch limit - a parameter that defines max number of objects that should be ever be fetched from the database.
ColumnSelect<T>	ColumnSelect.localCache() Instructs Cayenne to look for query results in the "local" cache when running the query.
ColumnSelect<T>	ColumnSelect.localCache(String cacheGroup) Instructs Cayenne to look for query results in the "local" cache when running the query.
ColumnSelect<Object[]>	ColumnSelect.max(Property<?> property) Select maximum value of property
<E> ColumnSelect<E>	ObjectSelect.max(Property<E> property) Select maximum value of property
ColumnSelect<Object[]>	ColumnSelect.min(Property<?> property) Select minimum value of property
<E> ColumnSelect<E>	ObjectSelect.min(Property<E> property) Select minimum value of property
ColumnSelect<T>	ColumnSelect.offset(int fetchOffset) Resets query fetch offset - a parameter that defines how many objects should be skipped when reading data from the database.
ColumnSelect<T>	ColumnSelect.or(Collection<Expression> expressions) OR's provided expressions to the existing WHERE or HAVING clause expression.
ColumnSelect<T>	ColumnSelect.or(Expression... expressions) OR's provided expressions to the existing WHERE clause expression.
ColumnSelect<T>	ColumnSelect.orderBy(Collection<Ordering> orderings) Adds a list of orderings to this query.
ColumnSelect<T>	ColumnSelect.orderBy(Ordering... orderings) Add one or more orderings to this query.
ColumnSelect<T>	ColumnSelect.orderBy(String property) Add an ascending ordering on the given property.
ColumnSelect<T>	ColumnSelect.orderBy(String property, SortOrder sortOrder) Add an ordering on the given property.
ColumnSelect<T>	ColumnSelect.pageSize(int pageSize) Resets query page size.
ColumnSelect<T>	ColumnSelect.prefetch(PrefetchTreeNode prefetch) Merges prefetch into the query prefetch tree.
ColumnSelect<T>	ColumnSelect.prefetch(String path, int semantics) Merges a prefetch path with specified semantics into the query prefetch tree.
ColumnSelect<T>	ColumnSelect.sharedCache() Instructs Cayenne to look for query results in the "shared" cache when running the query.
ColumnSelect<T>	ColumnSelect.sharedCache(String cacheGroup) Instructs Cayenne to look for query results in the "shared" cache when running the query.
ColumnSelect<T>	ColumnSelect.statementFetchSize(int size) Sets fetch size of the PreparedStatement generated for this query.
<E extends Number> ColumnSelect<E>	ObjectSelect.sum(Property<E> property) Select sum of values
<E extends Number> ColumnSelect<Object[]>	ColumnSelect.sum(Property<E> property) Select sum of values
ColumnSelect<T>	ColumnSelect.suppressDistinct() Explicitly suppress distinct in query.
ColumnSelect<T>	ColumnSelect.where(Expression expression) Appends a qualifier expression of this query.
ColumnSelect<T>	ColumnSelect.where(String expressionString, Object... parameters) Appends a qualifier expression of this query, using provided expression String and an array of position parameters.