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 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) 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.
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<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.
static <T extends StructuredType<T>> Select<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(Function<T,Value<Integer>> rows) Deprecated. instead use limit(int rows)
Select<T>	Select.limit(Function<T,Value<Integer>> rows, Function<T,Value<Integer>> offset) Deprecated. instead use limit(int rows, int offset)
abstract Select<T>	Select.limit(int rows) Sets the limit of the select statement.
abstract Select<T>	Select.limit(int rows, int offset) Sets the limit and offset of the select statement.
abstract Select<T>	Select.limit(Value<Integer> rows, Value<Integer> offset) Deprecated. instead use limit(int rows, int offset)
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>> 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)
<E extends StructuredType<E>> Select<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.

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

Modifier and Type	Method and 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 and Description
default Predicate	CqnModifier.exists(Select<?> subQuery)