Q - concrete typepublic interface SQLCommonQuery<Q extends SQLCommonQuery<Q>> extends Query<Q>
SQLCommonQuery is a common interface for SQLQuery and SQLSubQuery| Modifier and Type | Method and Description |
|---|---|
Q |
addFlag(QueryFlag.Position position,
Expression<?> flag)
Add the given Expression as a query flag
|
Q |
addFlag(QueryFlag.Position position,
java.lang.String flag)
Add the given String literal as query flag
|
Q |
addFlag(QueryFlag.Position position,
java.lang.String prefix,
Expression<?> expr)
Add the given prefix and expression as a general query flag
|
Q |
addJoinFlag(java.lang.String flag)
Add the given String literal as a join flag to the last added join with the
position BEFORE_TARGET
|
Q |
addJoinFlag(java.lang.String flag,
JoinFlag.Position position)
Add the given String literal as a join flag to the last added join
|
Q |
from(Expression<?>... o)
Defines the sources of the query
|
Q |
from(SubQueryExpression<?> subQuery,
Path<?> alias)
Adds a sub query source
|
Q |
fullJoin(EntityPath<?> o)
Adds a full join to the given target
|
<E> Q |
fullJoin(EntityPath<E> o,
Path<E> alias)
Adds a full join to the given target
|
<E> Q |
fullJoin(ForeignKey<E> key,
RelationalPath<E> entity)
Adds a full join to the given target
|
<E> Q |
fullJoin(RelationalFunctionCall<E> o,
Path<E> alias)
Adds a full join to the given target
|
Q |
fullJoin(SubQueryExpression<?> o,
Path<?> alias)
Adds a full join to the given target
|
Q |
innerJoin(EntityPath<?> o)
Adds an inner join to the given target
|
<E> Q |
innerJoin(EntityPath<E> o,
Path<E> alias)
Adds an inner join to the given target
|
<E> Q |
innerJoin(ForeignKey<E> foreign,
RelationalPath<E> entity)
Adds an inner join to the given target
|
<E> Q |
innerJoin(RelationalFunctionCall<E> o,
Path<E> alias)
Adds a inner join to the given target
|
Q |
innerJoin(SubQueryExpression<?> o,
Path<?> alias)
Adds an inner join to the given target
|
Q |
join(EntityPath<?> o)
Adds a join to the given target
|
<E> Q |
join(EntityPath<E> o,
Path<E> alias)
Adds a join to the given target
|
<E> Q |
join(ForeignKey<E> foreign,
RelationalPath<E> entity)
Adds a join to the given target
|
<E> Q |
join(RelationalFunctionCall<E> o,
Path<E> alias)
Adds a join to the given target
|
Q |
join(SubQueryExpression<?> o,
Path<?> alias)
Adds a join to the given target
|
Q |
leftJoin(EntityPath<?> o)
Adds a left join to the given target
|
<E> Q |
leftJoin(EntityPath<E> o,
Path<E> alias)
Adds a left join to the given target
|
<E> Q |
leftJoin(ForeignKey<E> foreign,
RelationalPath<E> entity)
Adds a left join to the given target
|
<E> Q |
leftJoin(RelationalFunctionCall<E> o,
Path<E> alias)
Adds a left join to the given target
|
Q |
leftJoin(SubQueryExpression<?> o,
Path<?> alias)
Adds a left join to the given target
|
Q |
on(Predicate... conditions)
Defines a filter to the last added join
|
Q |
rightJoin(EntityPath<?> o)
Adds a right join to the given target
|
<E> Q |
rightJoin(EntityPath<E> o,
Path<E> alias)
Adds a right join to the given target
|
<E> Q |
rightJoin(ForeignKey<E> foreign,
RelationalPath<E> entity)
Adds a right join to the given target
|
<E> Q |
rightJoin(RelationalFunctionCall<E> o,
Path<E> alias)
Adds a full join to the given target
|
Q |
rightJoin(SubQueryExpression<?> o,
Path<?> alias)
Adds a right join to the given target
|
Q |
with(Path<?> alias,
Expression<?> query)
Adds a common table expression
|
WithBuilder<Q> |
with(Path<?> alias,
Path<?>... columns)
Adds a common table expression
|
Q |
with(Path<?> alias,
SubQueryExpression<?> o)
Adds a common table expression
|
Q |
withRecursive(Path<?> alias,
Expression<?> query)
Adds a common table expression
|
WithBuilder<Q> |
withRecursive(Path<?> alias,
Path<?>... columns)
Adds a common table expression
|
Q |
withRecursive(Path<?> alias,
SubQueryExpression<?> o)
Adds a common table expression
|
distinct, limit, offset, orderBy, restrict, setwhereQ addFlag(QueryFlag.Position position, Expression<?> flag)
position - positionflag - query flagQ addFlag(QueryFlag.Position position, java.lang.String flag)
position - positionflag - query flagQ addFlag(QueryFlag.Position position, java.lang.String prefix, Expression<?> expr)
position - position of the flagprefix - prefix for the flagexpr - expression of the flagQ addJoinFlag(java.lang.String flag)
flag - join flagQ addJoinFlag(java.lang.String flag, JoinFlag.Position position)
flag - join flagposition - positionQ from(Expression<?>... o)
o - fromQ from(SubQueryExpression<?> subQuery, Path<?> alias)
subQuery - sub queryalias - aliasQ fullJoin(EntityPath<?> o)
o - full join target<E> Q fullJoin(EntityPath<E> o, Path<E> alias)
E - o - full join targetalias - alias<E> Q fullJoin(RelationalFunctionCall<E> o, Path<E> alias)
E - o - full join targetalias - alias<E> Q fullJoin(ForeignKey<E> key, RelationalPath<E> entity)
E - key - foreign key for joinentity - join targetQ fullJoin(SubQueryExpression<?> o, Path<?> alias)
o - subqueryalias - aliasQ innerJoin(EntityPath<?> o)
o - <E> Q innerJoin(EntityPath<E> o, Path<E> alias)
E - o - inner join targetalias - alias<E> Q innerJoin(RelationalFunctionCall<E> o, Path<E> alias)
E - o - relational function callalias - alias<E> Q innerJoin(ForeignKey<E> foreign, RelationalPath<E> entity)
E - foreign - foreign key to use for joinentity - join targetQ innerJoin(SubQueryExpression<?> o, Path<?> alias)
o - subqueryalias - aliasQ join(EntityPath<?> o)
o - join target<E> Q join(EntityPath<E> o, Path<E> alias)
E - o - join targetalias - alias<E> Q join(RelationalFunctionCall<E> o, Path<E> alias)
E - o - join targetalias - alias<E> Q join(ForeignKey<E> foreign, RelationalPath<E> entity)
E - foreign - foreign key to use for joinentity - join targetQ join(SubQueryExpression<?> o, Path<?> alias)
o - subqueryalias - aliasQ leftJoin(EntityPath<?> o)
o - join target<E> Q leftJoin(EntityPath<E> o, Path<E> alias)
E - o - left join targetalias - alias<E> Q leftJoin(RelationalFunctionCall<E> o, Path<E> alias)
E - o - relational function callalias - alias<E> Q leftJoin(ForeignKey<E> foreign, RelationalPath<E> entity)
E - foreign - foreign key to use for joinentity - join targetQ leftJoin(SubQueryExpression<?> o, Path<?> alias)
o - subqueryalias - aliasQ on(Predicate... conditions)
conditions - join conditionsQ rightJoin(EntityPath<?> o)
o - join target<E> Q rightJoin(EntityPath<E> o, Path<E> alias)
E - o - right join targetalias - alias<E> Q rightJoin(RelationalFunctionCall<E> o, Path<E> alias)
E - o - relational function callalias - alias<E> Q rightJoin(ForeignKey<E> foreign, RelationalPath<E> entity)
E - foreign - foreign key to use for joinentity - join targetQ rightJoin(SubQueryExpression<?> o, Path<?> alias)
o - subqueryalias - aliasQ with(Path<?> alias, SubQueryExpression<?> o)
Usage
query.with(alias, subQuery)
.from(...)
alias - alias for queryo - subqueryQ with(Path<?> alias, Expression<?> query)
Usage
query.with(alias, subQuery)
.from(...)
alias - alias for queryquery - subqueryWithBuilder<Q> with(Path<?> alias, Path<?>... columns)
Usage
query.with(alias, columns...).as(subQuery)
.from(...)
alias - alias for querycolumns - columns to useQ withRecursive(Path<?> alias, SubQueryExpression<?> o)
Usage
query.withRecursive(alias, subQuery)
.from(...)
alias - alias for queryo - subqueryQ withRecursive(Path<?> alias, Expression<?> query)
Usage
query.withRecursive(alias, subQuery)
.from(...)
alias - alias for queryquery - subqueryWithBuilder<Q> withRecursive(Path<?> alias, Path<?>... columns)
Usage
query.withRecursive(alias, columns...).as(subQuery)
.from(...)
alias - alias for querycolumns - columns to useCopyright © 2007–2021 Querydsl. All rights reserved.