public class SelectBuilder<T extends StructuredType<?>> extends Select<T>
Modifier and Type | Field and Description |
---|---|
static String |
IGNORE_DRAFT_SUBQUERIES |
static String |
IGNORE_LOCALIZED_VIEWS |
accept, columns, columns, cqn, excluding, excluding, from, from, from, from, from, groupBy, groupBy, limit, orderBy, orderBy, toString
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
public static final String IGNORE_LOCALIZED_VIEWS
public static final String IGNORE_DRAFT_SUBQUERIES
public static <E extends StructuredType<E>> SelectBuilder<E> from(Class<E> entity)
public static SelectBuilder<StructuredType<?>> from(CqnStructuredTypeRef ref)
public static Select<StructuredType<?>> from(CqnSelect select)
public static SelectBuilder<StructuredTypeImpl> from(CqnSource source)
public static <E extends StructuredType<E>,R extends StructuredType<R>> SelectBuilder<R> from(Class<E> type, Function<E,R> path)
public static <E extends StructuredType<E>> SelectBuilder<E> from(Source<E> source)
public static SelectBuilder<StructuredType<?>> from(String entityName)
public static SelectBuilder<StructuredType<?>> from(String entity, UnaryOperator<StructuredType<?>> path)
public static SelectBuilder<StructuredType<?>> copy(CqnSelect select)
public static SelectBuilder<StructuredType<?>> copy(CqnSelect select, CqnModifier modifier)
public static SelectBuilder<StructuredType<?>> copy(CqnSelect select, CqnModifier modifier, boolean deep)
public CqnStructuredTypeRef ref()
public SelectBuilder<T> distinct()
distinct
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> distinct(boolean distinct)
public boolean isDistinct()
public SelectBuilder<T> inlineCount()
inlineCount
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> count(boolean count)
public boolean hasInlineCount()
public SelectBuilder<T> columns(List<CqnSelectListItem> items)
columns
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> columns(Stream<CqnSelectListItem> items)
columns
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> columns(String... elements)
columns
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> addItem(CqnSelectListItem item)
public Select<T> columns(CqnLiteral<?> literal)
public List<CqnSelectListItem> items()
public SelectBuilder<T> excluding(Collection<String> slis)
excluding
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> addExclude(String slis)
public SelectBuilder<T> where(Function<T,CqnPredicate> pred)
where
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> where(CqnPredicate pred)
where
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> where(Optional<? extends CqnPredicate> optionalWhere)
public SelectBuilder<T> matching(Map<String,?> values)
matching
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> byId(Object idValue)
byId
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> search(String searchTerm)
search
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> search(String searchTerm, Iterable<String> searchableElements)
search
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> search(Function<Searchable,Predicate> pred)
search
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> search(Function<Searchable,Predicate> pred, Iterable<String> searchableElements)
search
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> search(CqnPredicate predicate)
search
in class Select<T extends StructuredType<?>>
public Collection<String> searchableElements()
public Optional<CqnPredicate> where()
public Optional<CqnPredicate> search()
public Select<T> lock(int timeout)
lock
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> groupBy(List<CqnSelectListItem> items)
groupBy
in class Select<T extends StructuredType<?>>
public Select<T> groupBy(String... refs)
groupBy
in class Select<T extends StructuredType<?>>
public List<CqnSelectListItem> groupBy()
public SelectBuilder<T> having(Function<T,CqnPredicate> pred)
having
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> having(CqnPredicate pred)
having
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> having(Optional<CqnPredicate> pred)
public Optional<CqnPredicate> having()
public final SelectBuilder<T> orderBy(List<CqnSortSpecification> sortSpec)
orderBy
in class Select<T extends StructuredType<?>>
public List<CqnSortSpecification> orderBy()
public Select<T> orderBy(String... refs)
orderBy
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> limit(long rows, long offset)
limit
in class Select<T extends StructuredType<?>>
public SelectBuilder<T> limit(CqnLimit limit)
public SelectBuilder<T> limit(Optional<CqnLimit> optionalLimit)
public CqnSelect build()
public T getType()
public static <U> Parameter<U> param()
public static <U> FunctionCall<U> func(String functionName, CqnValue... args)
public static <U> Literal<U> literal(U val)
public String toJson()
Copyright © 2021 SAP. All rights reserved.