Uses of Class
st.orm.template.QueryBuilder

Packages that use QueryBuilder

Package	Description
st.orm.repository
st.orm.template

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<T,R,ID>	QueryBuilder.append(StringTemplatePREVIEW template)	Append the query with a string template.
abstract QueryBuilder<T,R,ID>	QueryBuilder.crossJoin(Class<? extends Data> relation)	Adds a cross join to the query.
abstract QueryBuilder<T,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.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(Metamodel<T,?>... path)	Adds a GROUP BY clause to the query for field at the specified path in the table graph.
final QueryBuilder<T,R,ID>	QueryBuilder.groupByAny(Metamodel<?,?>... 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(Metamodel<T,V> path, Operator operator, V... o)	Adds a HAVING clause to the query using the specified expression.
final <V> QueryBuilder<T,R,ID>	QueryBuilder.havingAny(Metamodel<?,V> path, Operator operator, V... o)	Adds a HAVING clause to the query using the specified expression.
abstract QueryBuilder<T,R,ID>	QueryBuilder.limit(int limit)	Adds a LIMIT clause to the query.
abstract QueryBuilder<T,R,ID>	QueryBuilder.offset(int offset)	Adds an OFFSET clause to the query.
QueryBuilder<T,R,ID>	JoinBuilder.on(StringTemplatePREVIEW template)	Specifies the join condition using a custom expression.
QueryBuilder<T,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(Metamodel<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.orderByAny(Metamodel<?,?>... path)	Adds an ORDER BY clause to the query for the field at the specified path in the table graph or manually added joins.
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(Metamodel<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(Metamodel<T,?>... path)	Adds an ORDER BY clause to the query for the fields at the specified paths in the table graph.
final QueryBuilder<T,R,ID>	QueryBuilder.orderByDescendingAny(Metamodel<?,?> path)	Adds an ORDER BY clause to the query for the field at the specified path in the table graph or manually added joins.
final QueryBuilder<T,R,ID>	QueryBuilder.orderByDescendingAny(Metamodel<?,?>... path)	Adds an ORDER BY clause to the query for the fields at the specified paths in the table graph or manually added joins.
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.typed(Class<X> pkType)	Returns a typed query builder for the specified primary key type.
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(Metamodel<T,V> path, Iterable<V> it)	Adds a WHERE clause that matches the specified records.
final <V> QueryBuilder<T,R,ID>	QueryBuilder.where(Metamodel<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(Metamodel<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(Metamodel<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(Metamodel<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.
abstract QueryBuilder<T,R,ID>	QueryBuilder.whereAny(Function<WhereBuilder<T,R,ID>,PredicateBuilder<?,?,?>> predicate)	Adds a WHERE clause to the query using a WhereBuilder.
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.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(Metamodel<T,V> path, Iterable<? extends Ref<V>> it)	Adds a WHERE clause that matches the specified records.

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 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.