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

Packages that use ColumnSelect
Package
Description
org.apache.cayenne.exp
Cayenne data expression classes.
org.apache.cayenne.exp.property
Property API
org.apache.cayenne.query
Defines standard queries supported by Cayenne and extension mechanism to create custom queries.

- ## Uses of ColumnSelect in org.apache.cayenne.exp

  Methods in org.apache.cayenne.exp with parameters of type ColumnSelect
  Modifier and Type
  Method
  Description
  `static Expression`
  ExpressionFactory.`inExp(Expression exp, ColumnSelect<?> subQuery)`
  `static Expression`
  ExpressionFactory.`notInExp(Expression exp, ColumnSelect<?> subQuery)`

- ## Uses of ColumnSelect in org.apache.cayenne.exp.property

  Methods in org.apache.cayenne.exp.property with parameters of type ColumnSelect
  Modifier and Type
  Method
  Description
  `Expression`
  BaseProperty.`in(ColumnSelect<? extends E> subquery)`
  `Expression`
  BaseProperty.`nin(ColumnSelect<? extends E> subquery)`

- ## Uses of ColumnSelect in org.apache.cayenne.query

  Methods in org.apache.cayenne.query that return ColumnSelect
  Modifier and Type
  Method
  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(NumericProperty<?> property)`
  Select average value of property
  `ColumnSelect<Object[]>`
  ColumnSelect.`avg(Property<?> property)`
  Deprecated.
  since 4.2 use `avg(NumericProperty)`
  `<E extends Number>
  ColumnSelect<E>`
  ObjectSelect.`avg(NumericProperty<E> property)`
  Select average value of property
  `<E> ColumnSelect<E>`
  ObjectSelect.`avg(Property<E> property)`
  Deprecated.
  since 4.2 use `ObjectSelect.avg(NumericProperty)`
  `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<?>... columns)`
  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<?>... properties)`
  Add properties to select.
  `ColumnSelect<Object[]>`
  ObjectSelect.`columns(Property<?>... properties)`
  Select only specific properties.
  `ColumnSelect<Object[]>`
  ColumnSelect.`count()`
  Shortcut for `columns(Property[])` columns}(Property.COUNT)
  `ColumnSelect<Object[]>`
  ColumnSelect.`count(BaseProperty<?> property)`
  Select COUNT(property)
  `ColumnSelect<Long>`
  ObjectSelect.`count()`
  Select COUNT(*)
  `ColumnSelect<Long>`
  ObjectSelect.`count(BaseProperty<?> 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(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.`having(Expression expression)`
  Appends a having qualifier expression of this query.
  `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.
  `<E> ColumnSelect<E>`
  ColumnSelect.`map(Function<T,E> mapper)`
  Maps result of this query by processing with a given function.
  `ColumnSelect<Object[]>`
  ColumnSelect.`max(ComparableProperty<?> property)`
  Select maximum value of property
  `<E> ColumnSelect<E>`
  ObjectSelect.`max(ComparableProperty<E> property)`
  Select maximum value of property
  `<E extends Number>
  ColumnSelect<E>`
  ObjectSelect.`max(NumericProperty<E> property)`
  Select maximum value of property
  `ColumnSelect<Object[]>`
  ColumnSelect.`min(ComparableProperty<?> property)`
  Select minimum value of property
  `<E> ColumnSelect<E>`
  ObjectSelect.`min(ComparableProperty<E> property)`
  Select minimum value of property
  `<E extends Number>
  ColumnSelect<E>`
  ObjectSelect.`min(NumericProperty<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(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.`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.`pageSize(int pageSize)`
  Resets query page size.
  `ColumnSelect<T>`
  ColumnSelect.`prefetch(String path, int semantics)`
  Merges a prefetch path with specified semantics into the query prefetch tree.
  `ColumnSelect<T>`
  ColumnSelect.`prefetch(PrefetchTreeNode prefetch)`
  Merges prefetch into the query prefetch tree.
  `ColumnSelect<T>`
  ColumnSelect.`queryTimeout(int timeout)`
  Sets query timeout of PreparedStatement generated for this query.
  `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(NumericProperty<E> property)`
  Select sum of values
  `<E extends Number>
  ColumnSelect<Object[]>`
  ColumnSelect.`sum(Property<E> property)`
  Deprecated.
  since 4.2 use `sum(NumericProperty)`
  `<E extends Number>
  ColumnSelect<E>`
  ObjectSelect.`sum(NumericProperty<E> property)`
  Select sum of values
  `<E extends Number>
  ColumnSelect<E>`
  ObjectSelect.`sum(Property<E> property)`
  Deprecated.
  since 4.2 use `ObjectSelect.sum(NumericProperty)`
  `ColumnSelect<T>`
  ColumnSelect.`suppressDistinct()`
  Explicitly suppress distinct in 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.
  `ColumnSelect<T>`
  ColumnSelect.`where(Expression expression)`
  Appends a qualifier expression of this query.