public interface Detachable
Modifier and Type | Method and Description |
---|---|
NumberSubQuery<Long> |
count()
Return the count of matched rows as a sub query
|
BooleanExpression |
exists()
Create an exists(this) expression
|
ListSubQuery<Tuple> |
list(Expression<?>... args)
Create a multi row subquery expression for the given projection
|
<RT> ListSubQuery<RT> |
list(Expression<RT> projection)
Create a multi row subquery expression for the given projection
|
ListSubQuery<Tuple> |
list(Object... args)
Create a multi row subquery expression for the given projection
|
BooleanExpression |
notExists()
Create an not exists(this) expression
|
<RT extends Comparable<?>> |
unique(ComparableExpression<RT> projection)
Create a single row subquery expression for the given projection
|
<RT extends Comparable<?>> |
unique(DateExpression<RT> projection)
Create a single row subquery expression for the given projection
|
<RT extends Comparable<?>> |
unique(DateTimeExpression<RT> projection)
Create a single row subquery expression for the given projection
|
SimpleSubQuery<Tuple> |
unique(Expression<?>... args)
Create a single row subquery expression for the given projection
|
<RT> SimpleSubQuery<RT> |
unique(Expression<RT> projection)
Create a single row subquery expression for the given projection
|
<RT extends Number & Comparable<?>> |
unique(NumberExpression<RT> projection)
Create a single row subquery expression for the given projection
|
SimpleSubQuery<Tuple> |
unique(Object... args)
Create a single row subquery expression for the given projection
|
BooleanSubQuery |
unique(Predicate projection)
Create a single row subquery expression for the given projection
|
StringSubQuery |
unique(StringExpression projection)
Create a single row subquery expression for the given projection
|
<RT extends Comparable<?>> |
unique(TimeExpression<RT> projection)
Create a single row subquery expression for the given projection
|
NumberSubQuery<Long> count()
Usage
query.where(subQuery.from(customer).where(...).count().gt(1))
BooleanExpression exists()
Usage
query.where(subQuery.from(customer).where(...).exists())
ListSubQuery<Tuple> list(Expression<?>... args)
Usage
subQuery.from(person).list(person.firstName, person.lastName).countDistinct()
args
- ListSubQuery<Tuple> list(Object... args)
Non expression arguments are converted into constant expressions
Usage
subQuery.from(person).list(person.firstName, "M")
args
- <RT> ListSubQuery<RT> list(Expression<RT> projection)
Usage
customer.name.in(subQuery.from(customer).where(...).list(customer.name))
RT
- generic type of the Listprojection
- BooleanExpression notExists()
Usage
query.where(subQuery.from(customer).where(...).notExists())
SimpleSubQuery<Tuple> unique(Expression<?>... args)
Usage
subQuery.from(person).unique(person.firstName, person.lastName)
args
- SimpleSubQuery<Tuple> unique(Object... args)
Non expression arguments are converted into constant expressions
Usage
subQuery.from(person).unique(person.firstName, "M")
args
- <RT> SimpleSubQuery<RT> unique(Expression<RT> projection)
Usage
person.age.eq(subQuery.from(person).unique(person.age.max()))
RT
- return typeprojection
- BooleanSubQuery unique(Predicate projection)
projection
- unique(com.mysema.query.types.Expression)
StringSubQuery unique(StringExpression projection)
projection
- unique(com.mysema.query.types.Expression)
<RT extends Comparable<?>> ComparableSubQuery<RT> unique(ComparableExpression<RT> projection)
RT
- projection
- unique(com.mysema.query.types.Expression)
<RT extends Comparable<?>> DateSubQuery<RT> unique(DateExpression<RT> projection)
RT
- projection
- unique(com.mysema.query.types.Expression)
<RT extends Comparable<?>> DateTimeSubQuery<RT> unique(DateTimeExpression<RT> projection)
RT
- projection
- unique(com.mysema.query.types.Expression)
<RT extends Comparable<?>> TimeSubQuery<RT> unique(TimeExpression<RT> projection)
RT
- projection
- unique(com.mysema.query.types.Expression)
<RT extends Number & Comparable<?>> NumberSubQuery<RT> unique(NumberExpression<RT> projection)
RT
- projection
- unique(com.mysema.query.types.Expression)
Copyright © 2007–2015 Mysema Ltd. All rights reserved.