Package | Description |
---|---|
com.sap.cds.ql | |
com.sap.cds.ql.cqn |
Modifier and Type | Method and Description |
---|---|
abstract Select<T> |
Select.byId(Object idValue)
Sets the where condition of the select statement, requiring that the value of
the single key element of the target entity set is equal to the given
idValue.
|
Select<T> |
Select.columns(CqnSelectListItem... items)
Sets the projection of the select statement.
|
Select<T> |
Select.columns(Function<T,CqnSelectListItem>... items)
Sets the projection of the select statement.
|
abstract Select<T> |
Select.columns(List<CqnSelectListItem> items)
Sets the projection of the select statement.
|
abstract Select<T> |
Select.columns(Stream<CqnSelectListItem> items)
Sets the projection of the select statement.
|
abstract Select<T> |
Select.columns(String... elements)
Sets the projection of the select statement.
|
static Select<StructuredType<?>> |
Select.copy(CqnSelect select)
|
static Select<StructuredType<?>> |
Select.cqn(String cqnSelect)
Creates a select statement from a given CQN String.
|
abstract Select<T> |
Select.distinct()
Specifies that duplicate query results should be eliminated.
|
abstract Select<T> |
Select.excluding(Collection<String> qualifiedNames)
Sets the exclude list of the select statement.
|
Select<T> |
Select.excluding(Function<T,CqnSelectListValue>... items)
Sets the exclude list of the select statement.
|
Select<T> |
Select.excluding(String... qualifiedNames)
Sets the exclude list of the select statement.
|
static Select<StructuredType<?>> |
Select.from(CdsEntity entity)
Creates a select statement to select entries from a specified entity set.
|
static Select<StructuredType<?>> |
Select.from(CdsEntity entity,
UnaryOperator<StructuredType<?>> path)
Creates a select statement to select entries from a specified entity set.
|
static <R extends StructuredType<R>,T extends StructuredType<T>> |
Select.from(Class<R> entity,
Function<R,T> path)
Creates a select statement to select entries from a specified entity set.
|
static <T extends StructuredType<T>> |
Select.from(Class<T> entity)
Creates a select statement to select entries from a specified entity set.
|
static Select<StructuredType<?>> |
Select.from(CqnSelect subquery)
Creates a select statement to select entries from the result of a given
subquery.
|
static Select<StructuredType<?>> |
Select.from(CqnStructuredTypeRef ref)
Creates a select statement to select entries from a specified entity set.
|
static Select<StructuredType<?>> |
Select.from(String qualifiedName)
Creates a select statement to select entries from a specified entity set.
|
static Select<StructuredType<?>> |
Select.from(String entityName,
UnaryOperator<StructuredType<?>> path)
Creates a select statement to select entries from a specified entity set.
|
static <T extends StructuredType<T>> |
Select.from(StructuredType<T> entity)
Creates a select statement to select entries from a specified entity set.
|
Select<T> |
Select.groupBy(CqnElementRef... elements)
Sets the group by clause of the select statement.
|
Select<T> |
Select.groupBy(Function<T,CqnSelectListItem>... items)
Sets the group by clause of the select statement.
|
abstract Select<T> |
Select.groupBy(List<CqnSelectListItem> items)
Sets the group by clause of the select statement.
|
abstract Select<T> |
Select.groupBy(String... elements)
Sets the groupBy clause of the select statement.
|
abstract Select<T> |
Select.having(CqnPredicate pred)
Sets the having clause of the select statement.
|
abstract Select<T> |
Select.having(Function<T,CqnPredicate> pred)
Sets the having clause of the select statement.
|
abstract Select<T> |
Select.inlineCount()
Specifies that the total number of root entities matching this query shall be
returned along with the result.
|
Select<T> |
Select.limit(long rows)
Sets the limit of the select statement.
|
abstract Select<T> |
Select.limit(long rows,
long offset)
Sets the limit and offset of the select statement.
|
abstract Select<T> |
Select.lock()
Creates a write lock on the selected rows for a default number of seconds
specified by DB so that other queries cannot lock or change the data until
current transaction is finished.
|
abstract Select<T> |
Select.lock(int timeout)
Creates a write lock on the selected rows so that other queries cannot lock
or change the data until current transaction is finished.
|
abstract Select<T> |
Select.matching(Map<String,?> values)
Sets the where condition of the select statement.
|
Select<T> |
Select.orderBy(CqnSortSpecification... sortSpecs)
Sets the orderBy clause of the select statement.
|
Select<T> |
Select.orderBy(Function<T,CqnSortSpecification>... sortSpecs)
Sets the orderBy clause of the select statement.
|
abstract Select<T> |
Select.orderBy(List<CqnSortSpecification> sortSpecs)
Sets the orderBy clause of the select statement.
|
abstract Select<T> |
Select.orderBy(String... elements)
Sets the orderBy clause of the select statement.
|
abstract Select<T> |
Select.search(CqnPredicate pred)
Adds a search filter to this select statement, requiring that any searchable
element of the target entity set matches the given search predicate.
|
abstract Select<T> |
Select.search(Function<Searchable,Predicate> pred)
Adds a search filter to this select statement, requiring that any searchable
element of the target entity set matches the given search predicate.
|
abstract Select<T> |
Select.search(Function<Searchable,Predicate> pred,
Iterable<String> searchableElements)
Adds a search filter to this select statement, requiring that any searchable
element of the target entity set matches the given search predicate.
|
abstract Select<T> |
Select.search(String searchTerm)
Adds a search filter to this select statement, requiring that any searchable
element of the target entity set matches the given search term
|
abstract Select<T> |
Select.search(String searchTerm,
Iterable<String> searchableElements)
Adds a search filter to this select statement, requiring that any given
searchable element of the target entity set matches the given search term.
|
Select<StructuredType<?>> |
CqnBuilder.select(CdsEntity entity) |
Select<StructuredType<?>> |
CqnBuilder.select(CdsEntity entity,
UnaryOperator<StructuredType<?>> path) |
<E extends StructuredType<E>> |
CqnBuilder.select(Class<E> entity) |
<E extends StructuredType<E>,R extends StructuredType<R>> |
CqnBuilder.select(Class<E> entity,
Function<E,R> path) |
Select<StructuredType<?>> |
CqnBuilder.select(CqnSelect select) |
Select<StructuredType<?>> |
CqnBuilder.select(CqnStructuredTypeRef ref) |
<E extends StructuredType<E>> |
CqnBuilder.select(Source<E> source) |
Select<StructuredType<?>> |
CqnParser.select(String cqn) |
Select<StructuredType<?>> |
CqnBuilder.select(String entityName) |
Select<StructuredType<?>> |
CqnBuilder.select(String entityName,
UnaryOperator<StructuredType<?>> path) |
abstract Select<T> |
Select.where(CqnPredicate pred)
Sets the where condition of the select statement.
|
abstract Select<T> |
Select.where(Function<T,CqnPredicate> pred)
Sets the where condition of the select statement.
|
Modifier and Type | Method and Description |
---|---|
Predicate |
StructuredType.exists(Function<T,Select<?>> subQuery) |
Modifier and Type | Method and Description |
---|---|
default Predicate |
Modifier.exists(Select<?> subQuery) |
Copyright © 2021 SAP. All rights reserved.