# 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.`all(ColumnSelect<?> subquery)`
  `static Expression`
  ExpressionFactory.`any(ColumnSelect<?> subquery)`
  `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 that return ColumnSelect
  Modifier and Type
  Method
  Description
  `ColumnSelect<Object[]>`
  SelfProperty.`columnQuery(Property<?>... properties)`
  `<T> ColumnSelect<T>`
  SelfProperty.`columnQuery(Property<T> property)`
  Methods in org.apache.cayenne.exp.property with parameters of type ColumnSelect
  Modifier and Type
  Method
  Description
  `default Expression`
  ComparableProperty.`gtAll(ColumnSelect<E> subquery)`
  `default Expression`
  ComparableProperty.`gtAny(ColumnSelect<E> subquery)`
  `default Expression`
  ComparableProperty.`gteAll(ColumnSelect<E> subquery)`
  `default Expression`
  ComparableProperty.`gteAny(ColumnSelect<E> subquery)`
  `Expression`
  BaseProperty.`in(ColumnSelect<? extends E> subquery)`
  `default Expression`
  ComparableProperty.`ltAll(ColumnSelect<E> subquery)`
  `default Expression`
  ComparableProperty.`ltAny(ColumnSelect<E> subquery)`
  `default Expression`
  ComparableProperty.`lteAll(ColumnSelect<E> subquery)`
  `default Expression`
  ComparableProperty.`lteAny(ColumnSelect<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
  `<E> ColumnSelect<Object[]>`
  ColumnSelect.`aggregate(BaseProperty<E> property, String function, Class<E> type)`
  Select result of some function, that aggregates values.
  `<E> ColumnSelect<E>`
  ObjectSelect.`aggregate(BaseProperty<E> property, String function, Class<E> type)`
  Select result of some function, that aggregates values.
  `ColumnSelect<Object[]>`
  ColumnSelect.`avg(NumericProperty<?> property)`
  Select average value of property
  `<E extends Number>
  ColumnSelect<E>`
  ObjectSelect.`avg(NumericProperty<E> property)`
  Select average value of property
  `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.`distinct()`
  Explicitly request distinct in 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.
  `<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
  `<E extends Number>
  ColumnSelect<Object[]>`
  ColumnSelect.`sum(NumericProperty<E> property)`
  Select sum of values
  `<E extends Number>
  ColumnSelect<E>`
  ObjectSelect.`sum(NumericProperty<E> property)`
  Select sum of values
  `ColumnSelect<T>`
  ColumnSelect.`suppressDistinct()`
  Explicitly suppress distinct in query.