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.
|
<E extends Number> ColumnSelect<E> |
ObjectSelect.avg(NumericProperty<E> property) |
Select average value of property
|
<E> ColumnSelect<E> |
ObjectSelect.avg(Property<E> property) |
Deprecated.
|
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() |
|
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.
|
<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.
|
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.
|