## 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)`
    `protected <E> ColumnSelect<E>` | ColumnSelect.`column(Property<E> property)`
    `<E> ColumnSelect<E>` | ObjectSelect.`column(Property<E> property)` Select one specific 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[]>` | ColumnSelect.`columns(Property<?> firstProperty, Property<?>... otherProperties)` Add properties to select.
    `ColumnSelect<Object[]>` | ObjectSelect.`columns(Property<?> firstProperty, Property<?>... properties)` Select only specific properties.
    `ColumnSelect<Object[]>` | ColumnSelect.`count()` Shortcut for `columns(Property, Property[])` columns}(Property.COUNT)
    `ColumnSelect<Long>` | ObjectSelect.`count()` Select COUNT(*)
    `ColumnSelect<Object[]>` | ColumnSelect.`count(Property<?> property)` Select COUNT(property)
    `ColumnSelect<Long>` | ObjectSelect.`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<Object[]>` | ColumnSelect.`sum(Property<E> property)` Select sum of values
    `<E extends Number> ColumnSelect<E>` | ObjectSelect.`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.

Copyright © 2001–2023 Apache Cayenne. All rights reserved.