T
- The parent query builder typepublic interface SubqueryBuilder<T> extends BaseQueryBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>, GroupByBuilder<T,SubqueryBuilder<T>>, DistinctBuilder<T,SubqueryBuilder<T>>
afterKeyset, afterKeyset, afterKeyset, beforeKeyset, beforeKeyset, beforeKeyset, containsParameter, from, from, getCriteriaBuilderFactory, getMetamodel, getParameter, getParameters, getParameterValue, getQueryString, getResultType, innerJoin, innerJoinDefault, innerJoinDefaultOn, innerJoinOn, isParameterSet, join, joinDefault, joinDefaultOn, joinOn, leftJoin, leftJoinDefault, leftJoinDefaultOn, leftJoinOn, rightJoin, rightJoinDefault, rightJoinDefaultOn, rightJoinOn, setParameter, setParameter, setParameter
whereOr
where, whereCase, whereExists, whereNotExists, whereSimpleCase, whereSubquery, whereSubquery
orderBy, orderByAsc, orderByAsc, orderByDesc, orderByDesc
groupBy, groupBy
havingOr
having, havingCase, havingExists, havingNotExists, havingSimpleCase, havingSubquery, havingSubquery
distinct
T end()
SimpleCaseWhenBuilder<SubqueryBuilder<T>> selectSimpleCase(String expression)
SelectBuilder
SelectBuilder.selectSimpleCase(java.lang.String, java.lang.String)
but without an alias.selectSimpleCase
in interface BaseQueryBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
selectSimpleCase
in interface SelectBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
expression
- The case operandSimpleCaseWhenBuilder<SubqueryBuilder<T>> selectSimpleCase(String expression, String alias)
SelectBuilder
SimpleCaseWhenBuilder
with the given alias as select alias.
The expression is the case operand which will be compared to the when expressions defined in the subsequent SimpleCaseWhenBuilder.selectSimpleCase
in interface BaseQueryBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
selectSimpleCase
in interface SelectBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
expression
- The case operandalias
- The select alias for the simple case when expressionCaseWhenBuilder<SubqueryBuilder<T>> selectCase()
SelectBuilder
SelectBuilder.selectCase(java.lang.String)
but without an alias.selectCase
in interface BaseQueryBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
selectCase
in interface SelectBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
CaseWhenBuilder<SubqueryBuilder<T>> selectCase(String alias)
SelectBuilder
CaseWhenBuilder
with the given alias as select alias.selectCase
in interface BaseQueryBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
selectCase
in interface SelectBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
alias
- The select alias for the case when expressionSubqueryBuilder<T> select(String expression)
SelectBuilder
select
in interface BaseQueryBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
select
in interface SelectBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
expression
- The expression for the select clauseSubqueryBuilder<T> select(String expression, String alias)
SelectBuilder
select
in interface BaseQueryBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
select
in interface SelectBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
expression
- The expression for the select clausealias
- The alias for the expressionSubqueryInitiator<SubqueryBuilder<T>> selectSubquery()
SelectBuilder
SelectBuilder.selectSubquery(java.lang.String)
but without an alias.selectSubquery
in interface BaseQueryBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
selectSubquery
in interface SelectBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
SubqueryInitiator<SubqueryBuilder<T>> selectSubquery(String alias)
SelectBuilder
SubqueryInitiator
for the select item with the given alias.
When the builder finishes, the select item is added to the parent container represented by the type X
.selectSubquery
in interface BaseQueryBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
selectSubquery
in interface SelectBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
alias
- The select alias for the subquerySubqueryInitiator<SubqueryBuilder<T>> selectSubquery(String subqueryAlias, String expression, String selectAlias)
SelectBuilder
SubqueryInitiator
for a new select item with the given select alias.
All occurrences of
subqueryAlias
in expression
will be replaced by the subquery.
When the builder finishes, the select item is added to the parent container represented by the type X
.
selectSubquery
in interface BaseQueryBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
selectSubquery
in interface SelectBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be added as select item.
This expression contains the subqueryAlias
to define the insertion points for the subquery.selectAlias
- The select alias for the expressionSubqueryInitiator<SubqueryBuilder<T>> selectSubquery(String subqueryAlias, String expression)
SelectBuilder
SelectBuilder.selectSubquery(java.lang.String,java.lang.String,java.lang.String)
but without a select alias.selectSubquery
in interface BaseQueryBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
selectSubquery
in interface SelectBuilder<javax.persistence.Tuple,SubqueryBuilder<T>>
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be added as select itemCopyright © 2015 Blazebit. All Rights Reserved.