| Package | Description | 
|---|---|
| org.apache.cayenne.query | Defines standard queries supported by Cayenne and extension mechanism to create
custom queries. | 
| 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  ObjEntityclass. | 
| 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  DbEntityname 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  ObjEntityname 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. sum(Property<E> property)Select sum of values | 
| <E extends Number> | 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.