Uses of Class
st.orm.template.QueryBuilder

Packages that use QueryBuilder

Package	Description
st.orm.repository	Java repository API.
st.orm.template	Java client API: templates, query builders and transactions.

Uses of QueryBuilder in st.orm.repository

Methods in st.orm.repository that return QueryBuilder

Modifier and Type	Method	Description
QueryBuilder<E,?,ID>	EntityRepository.delete()	Creates a new query builder for delete entities of the type managed by this repository.
QueryBuilder<E,E,ID>	EntityRepository.select()	Creates a new query builder for selecting entities of the type managed by this repository.
<R> QueryBuilder<E,R,ID>	EntityRepository.select(Class<R> selectType)	Creates a new query builder for the specialized selectType.
<R> QueryBuilder<E,R,ID>	EntityRepository.select(Class<R> selectType, StringTemplatePREVIEW template)	Creates a new query builder for the specialized selectType and specialized template for the select clause.
QueryBuilder<P,P,ID>	ProjectionRepository.select()	Creates a new query builder for the projection type managed by this repository.
<R> QueryBuilder<P,R,ID>	ProjectionRepository.select(Class<R> selectType)	Creates a new query builder for the custom selectType.
<R> QueryBuilder<P,R,ID>	ProjectionRepository.select(Class<R> selectType, StringTemplatePREVIEW template)	Creates a new query builder for the custom selectType and custom template for the select clause.
QueryBuilder<E,Long,ID>	EntityRepository.selectCount()	Creates a new query builder for the entity type managed by this repository.
QueryBuilder<P,Long,ID>	ProjectionRepository.selectCount()	Creates a new query builder for the projection type managed by this repository.
QueryBuilder<E,Ref<E>,ID>	EntityRepository.selectRef()	Creates a new query builder for selecting refs to entities of the type managed by this repository.
<R extends Data> QueryBuilder<E,Ref<R>,ID>	EntityRepository.selectRef(Class<R> refType)	Creates a new query builder for selecting refs to entities of the type managed by this repository.
QueryBuilder<P,Ref<P>,ID>	ProjectionRepository.selectRef()	Creates a new query builder for selecting refs to projections of the type managed by this repository.
<R extends Data> QueryBuilder<P,Ref<R>,ID>	ProjectionRepository.selectRef(Class<R> refType)	Creates a new query builder for selecting refs to projections of the type managed by this repository.

Uses of QueryBuilder in st.orm.template

Methods in st.orm.template that return QueryBuilder

Modifier and Type	Method	Description
abstract QueryBuilder<Data,R,ID>	QueryBuilder.crossJoin(Class<? extends Data> relation)	Adds a cross join to the query.
abstract QueryBuilder<Data,R,ID>	QueryBuilder.crossJoin(StringTemplatePREVIEW template)	Adds a cross join to the query.
<T extends Data> QueryBuilder<T,?,?>	QueryTemplate.deleteFrom(Class<T> fromType)	Creates a query builder for the specified table to delete from.
abstract QueryBuilder<T,R,ID>	QueryBuilder.distinct()	Marks the current query as a distinct query.
abstract QueryBuilder<T,R,ID>	QueryBuilder.fetch(List<? extends Navigable<T,? extends Data>> paths)	Resolves the references at the specified paths as part of this query.
final QueryBuilder<T,R,ID>	QueryBuilder.fetch(Navigable<T,? extends Data>... path)	Resolves the references at the specified paths as part of this query.
abstract QueryBuilder<T,R,ID>	QueryBuilder.forLock(StringTemplatePREVIEW template)	Locks the selected rows using a custom lock mode.
abstract QueryBuilder<T,R,ID>	QueryBuilder.forShare()	Locks the selected rows for reading.
abstract QueryBuilder<T,R,ID>	QueryBuilder.forUpdate()	Locks the selected rows for reading.
abstract QueryBuilder<T,R,ID>	QueryBuilder.groupBy(StringTemplatePREVIEW template)	Adds a GROUP BY clause to the query using a string template.
final QueryBuilder<T,R,ID>	QueryBuilder.groupBy(Navigable<? extends T,?>... path)	Adds a GROUP BY clause to the query for field at the specified path in the table graph.
abstract QueryBuilder<T,R,ID>	QueryBuilder.having(StringTemplatePREVIEW template)	Adds a HAVING clause to the query using the specified expression.
final <V> QueryBuilder<T,R,ID>	QueryBuilder.having(Navigable<? extends T,V> path, Operator operator, V... o)	Adds a HAVING clause to the query using the specified expression.
abstract QueryBuilder<T,R,ID>	QueryBuilder.havingExists(QueryBuilder<?,?,?> subquery)	Adds a HAVING clause that keeps the groups for which the specified subquery returns at least one row.
abstract QueryBuilder<T,R,ID>	QueryBuilder.havingNotExists(QueryBuilder<?,?,?> subquery)	Adds a HAVING clause that keeps the groups for which the specified subquery returns no rows.
abstract QueryBuilder<T,R,ID>	QueryBuilder.limit(int limit)	Adds a LIMIT clause to the query.
abstract <X extends Data> QueryBuilder<X,R,ID>	QueryBuilder.narrow(Class<X> rootType)	Returns a query builder rooted at the specified type, narrowing a builder whose root was relaxed by a join.
abstract QueryBuilder<T,R,ID>	QueryBuilder.offset(int offset)	Adds an OFFSET clause to the query.
QueryBuilder<Data,R,ID>	JoinBuilder.on(StringTemplatePREVIEW template)	Specifies the join condition using a custom expression.
QueryBuilder<Data,R,ID>	TypedJoinBuilder.on(Class<? extends Data> relation)	Specifies the relation to join on.
abstract QueryBuilder<T,R,ID>	QueryBuilder.orderBy(StringTemplatePREVIEW template)	Adds an ORDER BY clause to the query using a string template.
final QueryBuilder<T,R,ID>	QueryBuilder.orderBy(Navigable<? extends T,?>... path)	Adds an ORDER BY clause to the query for the field at the specified path in the table graph.
final QueryBuilder<T,R,ID>	QueryBuilder.orderByDescending(StringTemplatePREVIEW template)	Adds an ORDER BY clause to the query using a string template.
final QueryBuilder<T,R,ID>	QueryBuilder.orderByDescending(Navigable<? extends T,?> path)	Adds an ORDER BY clause to the query for the field at the specified path in the table graph.
final QueryBuilder<T,R,ID>	QueryBuilder.orderByDescending(Navigable<? extends T,?>... path)	Adds an ORDER BY clause to the query for the fields at the specified paths in the table graph.
default <T extends Data> QueryBuilder<T,T,?>	QueryTemplate.selectFrom(Class<T> fromType)	Creates a query builder for the specified table.
default <T extends Data, R> QueryBuilder<T,R,?>	QueryTemplate.selectFrom(Class<T> fromType, Class<R> selectType)	Creates a query builder for the specified table and select type.
<T extends Data, R> QueryBuilder<T,R,?>	QueryTemplate.selectFrom(Class<T> fromType, Class<R> selectType, StringTemplatePREVIEW template)	Creates a query builder for the specified table and select type using the given template.
default <T extends Data> QueryBuilder<T,?,?>	SubqueryTemplate.subquery(Class<T> fromType)	Create a subquery for the given table.
default <T extends Data, R extends Data> QueryBuilder<T,?,?>	SubqueryTemplate.subquery(Class<T> fromType, Class<R> selectType)	Create a subquery for the given table and select type.
<T extends Data> QueryBuilder<T,?,?>	SubqueryTemplate.subquery(Class<T> fromType, StringTemplatePREVIEW template)	Create a subquery for the given table and select type using the given template.
abstract <X> QueryBuilder<T,R,X>	QueryBuilder.typedId(Class<X> pkType)	Returns a query builder whose primary key type is pkType, so the operations that take an id can be used.
abstract QueryBuilder<T,R,ID>	QueryBuilder.unsafe()	Returns a query builder that allows UPDATE and DELETE queries without a WHERE clause.
final QueryBuilder<T,R,ID>	QueryBuilder.where(ID id)	Adds a WHERE clause that matches the specified primary key of the table.
final QueryBuilder<T,R,ID>	QueryBuilder.where(Iterable<? extends T> it)	Adds a WHERE clause that matches the specified records.
final QueryBuilder<T,R,ID>	QueryBuilder.where(StringTemplatePREVIEW template)	Adds a WHERE clause to the query for the specified expression.
abstract QueryBuilder<T,R,ID>	QueryBuilder.where(Function<WhereBuilder<T,R,ID>,PredicateBuilder<T,?,?>> predicate)	Adds a WHERE clause to the query using a WhereBuilder.
final <V extends Data> QueryBuilder<T,R,ID>	QueryBuilder.where(Navigable<? extends T,V> path, Iterable<V> it)	Adds a WHERE clause that matches the specified records.
final <V> QueryBuilder<T,R,ID>	QueryBuilder.where(Navigable<? extends T,V> path, Operator operator, Iterable<? extends V> it)	Adds a WHERE clause that matches the specified objects at the specified path in the table graph.
final <V> QueryBuilder<T,R,ID>	QueryBuilder.where(Navigable<? extends T,V> path, Operator operator, V... o)	Adds a WHERE clause that matches the specified objects at the specified path in the table graph.
final <V extends Data> QueryBuilder<T,R,ID>	QueryBuilder.where(Navigable<? extends T,V> path, Ref<V> ref)	Adds a WHERE clause that matches the specified ref.
final <V extends Record> QueryBuilder<T,R,ID>	QueryBuilder.where(Navigable<? extends T,V> path, V record)	Adds a WHERE clause that matches the specified record.
final QueryBuilder<T,R,ID>	QueryBuilder.where(Ref<T> ref)	Adds a WHERE clause that matches the specified primary key of the table, expressed by a ref.
final QueryBuilder<T,R,ID>	QueryBuilder.where(T record)	Adds a WHERE clause that matches the specified record.
final QueryBuilder<T,R,ID>	QueryBuilder.whereExists(QueryBuilder<?,?,?> subquery)	Adds a WHERE clause that keeps the rows for which the specified subquery returns at least one row.
final QueryBuilder<T,R,ID>	QueryBuilder.whereId(Iterable<? extends ID> it)	Adds a WHERE clause that matches the specified primary keys of the table.
final QueryBuilder<T,R,ID>	QueryBuilder.whereNotExists(QueryBuilder<?,?,?> subquery)	Adds a WHERE clause that keeps the rows for which the specified subquery returns no rows.
final QueryBuilder<T,R,ID>	QueryBuilder.whereRef(Iterable<? extends Ref<T>> it)	Adds a WHERE clause that matches the specified primary keys of the table, expressed by a ref.
final <V extends Data> QueryBuilder<T,R,ID>	QueryBuilder.whereRef(Navigable<? extends T,V> path, Iterable<? extends Ref<V>> it)	Adds a WHERE clause that matches the specified records.
abstract QueryBuilder<Data,R,ID>	QueryBuilder.widen()	Widens the query as a join does, without joining: from here on, every clause accepts paths from any entity in the query.

Methods in st.orm.template with parameters of type QueryBuilder

Modifier and Type	Method	Description
abstract PredicateBuilder<T,R,ID>	WhereBuilder.exists(QueryBuilder<?,?,?> subquery)	Adds an EXISTS condition to the WHERE clause using the specified subquery.
abstract QueryBuilder<T,R,ID>	QueryBuilder.havingExists(QueryBuilder<?,?,?> subquery)	Adds a HAVING clause that keeps the groups for which the specified subquery returns at least one row.
abstract QueryBuilder<T,R,ID>	QueryBuilder.havingNotExists(QueryBuilder<?,?,?> subquery)	Adds a HAVING clause that keeps the groups for which the specified subquery returns no rows.
abstract JoinBuilder<T,R,ID>	QueryBuilder.join(JoinType type, QueryBuilder<?,?,?> subquery, String alias)	Adds a join of the specified type to the query using a subquery.
abstract PredicateBuilder<T,R,ID>	WhereBuilder.notExists(QueryBuilder<?,?,?> subquery)	Adds an NOT EXISTS condition to the WHERE clause using the specified subquery.
static Element	Templates.subquery(QueryBuilder<?,?,?> builder, boolean correlate)	Creates a new subquery element using a query builder.
final QueryBuilder<T,R,ID>	QueryBuilder.whereExists(QueryBuilder<?,?,?> subquery)	Adds a WHERE clause that keeps the rows for which the specified subquery returns at least one row.
final QueryBuilder<T,R,ID>	QueryBuilder.whereNotExists(QueryBuilder<?,?,?> subquery)	Adds a WHERE clause that keeps the rows for which the specified subquery returns no rows.