Uses of Class
com.sap.cds.ql.Select

Packages that use Select

Package	Description
com.sap.cds.ql
com.sap.cds.ql.cqn

Uses of Select in com.sap.cds.ql

Methods in com.sap.cds.ql that return Select

Modifier and Type	Method	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.byParams(String... elementRefs)	Sets the where condition of the select statement.
abstract Select<T>	Select.byParams(Collection<String> elementRefs)	Sets the where condition of the select statement.
final Select<T>	Select.columns(Selectable... items)	Sets the projection of the select statement.
abstract Select<T>	Select.columns(String... elements)	Sets the projection of the select statement.
final Select<T>	Select.columns(Function<T,? extends Selectable>... items)	Sets the projection of the select statement.
abstract Select<T>	Select.columns(List<? extends Selectable> items)	Sets the projection of the select statement.
abstract Select<T>	Select.columns(Stream<? extends Selectable> items)	Sets the projection of the select statement.
static Select<StructuredType<?>>	Select.copy(CqnSelect select)	Copies the given CqnSelect into a Select builder.
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.
final Select<T>	Select.excluding(String... qualifiedNames)	Sets the exclude list of the select statement.
abstract Select<T>	Select.excluding(Collection<String> qualifiedNames)	Sets the exclude list of the select statement.
final Select<T>	Select.excluding(Function<T,CqnSelectListValue>... items)	Sets the exclude list of the select statement.
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 <T extends StructuredType<T>> Select<T>	Select.from(StructuredType<T> entity)	Creates a select statement to select entries from a specified entity set.
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<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<T>	Select.from(Class<T> entity)	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.
final Select<T>	Select.groupBy(CqnValue... dimensions)	Sets the group by clause of the select statement.
abstract Select<T>	Select.groupBy(String... elements)	Sets the groupBy clause of the select statement.
final Select<T>	Select.groupBy(Function<T,CqnValue>... dimensions)	Sets the group by clause of the select statement.
abstract Select<T>	Select.groupBy(List<? extends CqnValue> dimensions)	Sets the group by clause of the select statement.
abstract Select<T>	Select.groupBy(Stream<? extends CqnValue> dimensions)	Sets the group by 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 top)	Sets the limit of the select statement.
abstract Select<T>	Select.limit(long top, long skip)	Sets the limit and offset of the select statement.
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.
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.lock(CqnLock.Mode mode)	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(CqnLock.Mode mode, 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.
final Select<T>	Select.orderBy(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.
final 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.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(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.
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.
Select<StructuredType<?>>	CqnBuilder.select(CqnSelect select)
Select<StructuredType<?>>	CqnBuilder.select(CqnStructuredTypeRef ref)
<E extends StructuredType<E>> Select<E>	CqnBuilder.select(Source<E> source)
Select<StructuredType<?>>	CqnBuilder.select(CdsEntity entity)
Select<StructuredType<?>>	CqnBuilder.select(CdsEntity entity, UnaryOperator<StructuredType<?>> path)
<E extends StructuredType<E>> Select<E>	CqnBuilder.select(Class<E> entity)
<E extends StructuredType<E>, R extends StructuredType<R>> Select<R>	CqnBuilder.select(Class<E> entity, Function<E,R> path)
Select<StructuredType<?>>	CqnBuilder.select(String entityName)
Select<StructuredType<?>>	CqnBuilder.select(String entityName, UnaryOperator<StructuredType<?>> path)
Select<StructuredType<?>>	CqnParser.select(String cqn)
abstract Select<T>	Select.where(CqnPredicate pred)	Sets the where condition of this select statement to a given predicate.
abstract Select<T>	Select.where(Function<T,CqnPredicate> pred)	Sets the where condition of this select statement.

Method parameters in com.sap.cds.ql with type arguments of type Select

Modifier and Type	Method	Description
Predicate	StructuredType.exists(Function<T,Select<?>> subQuery)

Uses of Select in com.sap.cds.ql.cqn

Methods in com.sap.cds.ql.cqn with parameters of type Select

Modifier and Type	Method	Description
default CqnPredicate	Modifier.exists(Select<?> subQuery)	Override this method to replace an exist subquery.