FieldExpression (requery API)

java.lang.Object
- io.requery.query.FieldExpression<V>

Type Parameters:

V - field type

All Implemented Interfaces:

Aliasable<Expression<V>>, Conditional<LogicalCondition<? extends Expression<V>,?>,V>, Expression<V>, Functional<V>

Direct Known Subclasses:

AliasedExpression, AttributeBuilder, Function, NamedExpression
```
public abstract class FieldExpression<V>
extends Object
implements Expression<V>, Functional<V>, Aliasable<Expression<V>>, Conditional<LogicalCondition<? extends Expression<V>,?>,V>
```
Represents a field expression for which functions, aliasing etc can be applied.

Constructor Summary

Constructors
Modifier Constructor and Description

protected FieldExpression()

Constructors
Modifier	Constructor and Description
`protected`	`FieldExpression()`

Method Summary

All Methods Instance Methods Abstract Methods Concrete Methods
Modifier and Type	Method and Description
`Abs<V>`	`abs()`
`Expression<V>`	`as(String alias)` Alias the instance with the given valid name.
`OrderingExpression<V>`	`asc()`
`Avg<V>`	`avg()`
`LogicalCondition<? extends Expression<V>,Object>`	`between(V start, V end)` Applies the between condition
`OrderingExpression<V>`	`desc()`
`LogicalCondition<? extends Expression<V>,? extends Expression<V>>`	`eq(Expression<V> value)` Applies the equal condition, equivalent to `Conditional.equal(Object)`.
`LogicalCondition<? extends Expression<V>,V>`	`eq(V value)` Applies the equal condition, equivalent to `Conditional.equal(Object)`.
`LogicalCondition<? extends Expression<V>,? extends Expression<V>>`	`equal(Expression<V> value)` Applies the equal condition
`LogicalCondition<? extends Expression<V>,V>`	`equal(V value)` Applies the equal condition
`boolean`	`equals(Object obj)`
`Function<V>`	`function(String name)`
`String`	`getAlias()`
`abstract Class<V>`	`getClassType()`
`abstract ExpressionType`	`getExpressionType()`
`abstract String`	`getName()`
`LogicalCondition<? extends Expression<V>,? extends Expression<V>>`	`greaterThan(Expression<V> value)` Applies the greater than condition
`LogicalCondition<? extends Expression<V>,V>`	`greaterThan(V value)` Applies the greater than condition
`LogicalCondition<? extends Expression<V>,? extends Expression<V>>`	`greaterThanOrEqual(Expression<V> value)` Applies the greater than or equal to condition
`LogicalCondition<? extends Expression<V>,V>`	`greaterThanOrEqual(V value)` Applies the greater than or equal to condition
`LogicalCondition<? extends Expression<V>,? extends Expression<V>>`	`gt(Expression<V> value)` Applies the greater than condition, equivalent to `Conditional.greaterThan(Object)`.
`LogicalCondition<? extends Expression<V>,V>`	`gt(V value)` Applies the greater than condition, equivalent to `Conditional.greaterThan(Object)`.
`LogicalCondition<? extends Expression<V>,? extends Expression<V>>`	`gte(Expression<V> value)` Applies the greater than or equal to condition, equivalent to `Conditional.greaterThanOrEqual(Object)`.
`LogicalCondition<? extends Expression<V>,V>`	`gte(V value)` Applies the greater than or equal to condition, equivalent to `Conditional.greaterThanOrEqual(Object)`.
`int`	`hashCode()`
`LogicalCondition<? extends Expression<V>,Collection<V>>`	`in(Collection<V> values)` Applies the in condition, checking if the condition is applicable to the values in the given collection.
`LogicalCondition<? extends Expression<V>,? extends Return<?>>`	`in(Return<?> query)` Applies the equal condition
`LogicalCondition<? extends Expression<V>,V>`	`isNull()` Applies the 'is null' condition
`LogicalCondition<? extends Expression<V>,? extends Expression<V>>`	`lessThan(Expression<V> value)` Applies the less than condition
`LogicalCondition<? extends Expression<V>,V>`	`lessThan(V value)` Applies the less than condition
`LogicalCondition<? extends Expression<V>,? extends Expression<V>>`	`lessThanOrEqual(Expression<V> value)` Applies the less than or equal to condition
`LogicalCondition<? extends Expression<V>,V>`	`lessThanOrEqual(V value)` Applies the less than or equal to condition
`LogicalCondition<? extends Expression<V>,String>`	`like(String expression)` Applies the equal condition
`Lower<V>`	`lower()`
`LogicalCondition<? extends Expression<V>,? extends Expression<V>>`	`lt(Expression<V> value)` Applies the less than condition, equivalent to `Conditional.lessThan(Object)`.
`LogicalCondition<? extends Expression<V>,V>`	`lt(V value)` Applies the less than condition, equivalent to `Conditional.lessThan(Object)`.
`LogicalCondition<? extends Expression<V>,? extends Expression<V>>`	`lte(Expression<V> value)` Applies the less than or equal to condition, equivalent to `Conditional.lessThanOrEqual(Object)`.
`LogicalCondition<? extends Expression<V>,V>`	`lte(V value)` Applies the less than or equal to condition, equivalent to `Conditional.lessThanOrEqual(Object)`.
`Max<V>`	`max()`
`Min<V>`	`min()`
`LogicalCondition<? extends Expression<V>,? extends Expression<V>>`	`ne(Expression<V> value)` Applies the not equal condition, equivalent to `Conditional.notEqual(Object)`.
`LogicalCondition<? extends Expression<V>,V>`	`ne(V value)` Applies the not equal condition, equivalent to `Conditional.notEqual(Object)`.
`LogicalCondition<? extends Expression<V>,? extends Expression<V>>`	`notEqual(Expression<V> value)` Applies the not equal condition, maybe null, which is equivalent to `Conditional.notNull()`
`LogicalCondition<? extends Expression<V>,V>`	`notEqual(V value)` Applies the not equal condition, maybe null, which is equivalent to `Conditional.notNull()`
`LogicalCondition<? extends Expression<V>,Collection<V>>`	`notIn(Collection<V> values)` Applies the not in condition, checking if the condition is not applicable to the values in the collection.
`LogicalCondition<? extends Expression<V>,? extends Return<?>>`	`notIn(Return<?> query)` Applies the equal condition
`LogicalCondition<? extends Expression<V>,String>`	`notLike(String expression)` Applies the not like condition
`LogicalCondition<? extends Expression<V>,V>`	`notNull()` Applies the 'not null' condition
`Round<V>`	`round()`
`Round<V>`	`round(int decimals)`
`Substr<V>`	`substr(int offset, int length)`
`Sum<V>`	`sum()`
`Trim<V>`	`trim()`
`Trim<V>`	`trim(String chars)`
`Upper<V>`	`upper()`

Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - FieldExpression
```
protected FieldExpression()
```
- Method Detail
  - getName
```
public abstract String getName()
```
    Specified by:
    
    getName in interface Expression<V>
    
    Returns:
    
    identifier of the expression
  - getExpressionType
```
public abstract ExpressionType getExpressionType()
```
    Specified by:
    
    getExpressionType in interface Expression<V>
    
    Returns:
    
    type of the expression
  - getClassType
```
public abstract Class<V> getClassType()
```
    Specified by:
    
    getClassType in interface Expression<V>
    
    Returns:
    
    Class that results when the expression is evaluated
  - as
```
public Expression<V> as(String alias)
```
    Description copied from interface: Aliasable
    
    Alias the instance with the given valid name.
    
    Specified by:
    
    as in interface Aliasable<Expression<V>>
    
    Parameters:
    
    alias - name
    
    Returns:
    
    type after aliasing
  - getAlias
```
public String getAlias()
```
    Specified by:
    
    getAlias in interface Aliasable<Expression<V>>
    
    Returns:
    
    the current alias name.
  - asc
```
public OrderingExpression<V> asc()
```
    Specified by:
    
    asc in interface Functional<V>
  - desc
```
public OrderingExpression<V> desc()
```
    Specified by:
    
    desc in interface Functional<V>
  - abs
```
public Abs<V> abs()
```
    Specified by:
    
    abs in interface Functional<V>
  - max
```
public Max<V> max()
```
    Specified by:
    
    max in interface Functional<V>
  - min
```
public Min<V> min()
```
    Specified by:
    
    min in interface Functional<V>
  - avg
```
public Avg<V> avg()
```
    Specified by:
    
    avg in interface Functional<V>
  - sum
```
public Sum<V> sum()
```
    Specified by:
    
    sum in interface Functional<V>
  - round
```
public Round<V> round()
```
    Specified by:
    
    round in interface Functional<V>
  - round
```
public Round<V> round(int decimals)
```
    Specified by:
    
    round in interface Functional<V>
  - trim
```
public Trim<V> trim(String chars)
```
    Specified by:
    
    trim in interface Functional<V>
  - trim
```
public Trim<V> trim()
```
    Specified by:
    
    trim in interface Functional<V>
  - substr
```
public Substr<V> substr(int offset,
                        int length)
```
    Specified by:
    
    substr in interface Functional<V>
  - upper
```
public Upper<V> upper()
```
    Specified by:
    
    upper in interface Functional<V>
  - lower
```
public Lower<V> lower()
```
    Specified by:
    
    lower in interface Functional<V>
  - function
```
public Function<V> function(String name)
```
    Specified by:
    
    function in interface Functional<V>
  - equal
```
public LogicalCondition<? extends Expression<V>,V> equal(V value)
```
    Description copied from interface: Conditional
    
    Applies the equal condition
    
    Specified by:
    
    equal in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare, maybe null, which is equivalent to Conditional.isNull()
    
    Returns:
    
    next query step
  - notEqual
```
public LogicalCondition<? extends Expression<V>,V> notEqual(V value)
```
    Description copied from interface: Conditional
    
    Applies the not equal condition, maybe null, which is equivalent to Conditional.notNull()
    
    Specified by:
    
    notEqual in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lessThan
```
public LogicalCondition<? extends Expression<V>,V> lessThan(V value)
```
    Description copied from interface: Conditional
    
    Applies the less than condition
    
    Specified by:
    
    lessThan in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - greaterThan
```
public LogicalCondition<? extends Expression<V>,V> greaterThan(V value)
```
    Description copied from interface: Conditional
    
    Applies the greater than condition
    
    Specified by:
    
    greaterThan in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lessThanOrEqual
```
public LogicalCondition<? extends Expression<V>,V> lessThanOrEqual(V value)
```
    Description copied from interface: Conditional
    
    Applies the less than or equal to condition
    
    Specified by:
    
    lessThanOrEqual in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - greaterThanOrEqual
```
public LogicalCondition<? extends Expression<V>,V> greaterThanOrEqual(V value)
```
    Description copied from interface: Conditional
    
    Applies the greater than or equal to condition
    
    Specified by:
    
    greaterThanOrEqual in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - equal
```
public LogicalCondition<? extends Expression<V>,? extends Expression<V>> equal(Expression<V> value)
```
    Description copied from interface: Conditional
    
    Applies the equal condition
    
    Specified by:
    
    equal in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare, maybe null, which is equivalent to Conditional.isNull()
    
    Returns:
    
    next query step
  - notEqual
```
public LogicalCondition<? extends Expression<V>,? extends Expression<V>> notEqual(Expression<V> value)
```
    Description copied from interface: Conditional
    
    Applies the not equal condition, maybe null, which is equivalent to Conditional.notNull()
    
    Specified by:
    
    notEqual in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lessThan
```
public LogicalCondition<? extends Expression<V>,? extends Expression<V>> lessThan(Expression<V> value)
```
    Description copied from interface: Conditional
    
    Applies the less than condition
    
    Specified by:
    
    lessThan in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - greaterThan
```
public LogicalCondition<? extends Expression<V>,? extends Expression<V>> greaterThan(Expression<V> value)
```
    Description copied from interface: Conditional
    
    Applies the greater than condition
    
    Specified by:
    
    greaterThan in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lessThanOrEqual
```
public LogicalCondition<? extends Expression<V>,? extends Expression<V>> lessThanOrEqual(Expression<V> value)
```
    Description copied from interface: Conditional
    
    Applies the less than or equal to condition
    
    Specified by:
    
    lessThanOrEqual in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - greaterThanOrEqual
```
public LogicalCondition<? extends Expression<V>,? extends Expression<V>> greaterThanOrEqual(Expression<V> value)
```
    Description copied from interface: Conditional
    
    Applies the greater than or equal to condition
    
    Specified by:
    
    greaterThanOrEqual in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - eq
```
public LogicalCondition<? extends Expression<V>,V> eq(V value)
```
    Description copied from interface: Conditional
    
    Applies the equal condition, equivalent to Conditional.equal(Object).
    
    Specified by:
    
    eq in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - ne
```
public LogicalCondition<? extends Expression<V>,V> ne(V value)
```
    Description copied from interface: Conditional
    
    Applies the not equal condition, equivalent to Conditional.notEqual(Object).
    
    Specified by:
    
    ne in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lt
```
public LogicalCondition<? extends Expression<V>,V> lt(V value)
```
    Description copied from interface: Conditional
    
    Applies the less than condition, equivalent to Conditional.lessThan(Object).
    
    Specified by:
    
    lt in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - gt
```
public LogicalCondition<? extends Expression<V>,V> gt(V value)
```
    Description copied from interface: Conditional
    
    Applies the greater than condition, equivalent to Conditional.greaterThan(Object).
    
    Specified by:
    
    gt in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lte
```
public LogicalCondition<? extends Expression<V>,V> lte(V value)
```
    Description copied from interface: Conditional
    
    Applies the less than or equal to condition, equivalent to Conditional.lessThanOrEqual(Object).
    
    Specified by:
    
    lte in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - gte
```
public LogicalCondition<? extends Expression<V>,V> gte(V value)
```
    Description copied from interface: Conditional
    
    Applies the greater than or equal to condition, equivalent to Conditional.greaterThanOrEqual(Object).
    
    Specified by:
    
    gte in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - eq
```
public LogicalCondition<? extends Expression<V>,? extends Expression<V>> eq(Expression<V> value)
```
    Description copied from interface: Conditional
    
    Applies the equal condition, equivalent to Conditional.equal(Object).
    
    Specified by:
    
    eq in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - ne
```
public LogicalCondition<? extends Expression<V>,? extends Expression<V>> ne(Expression<V> value)
```
    Description copied from interface: Conditional
    
    Applies the not equal condition, equivalent to Conditional.notEqual(Object).
    
    Specified by:
    
    ne in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lt
```
public LogicalCondition<? extends Expression<V>,? extends Expression<V>> lt(Expression<V> value)
```
    Description copied from interface: Conditional
    
    Applies the less than condition, equivalent to Conditional.lessThan(Object).
    
    Specified by:
    
    lt in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - gt
```
public LogicalCondition<? extends Expression<V>,? extends Expression<V>> gt(Expression<V> value)
```
    Description copied from interface: Conditional
    
    Applies the greater than condition, equivalent to Conditional.greaterThan(Object).
    
    Specified by:
    
    gt in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lte
```
public LogicalCondition<? extends Expression<V>,? extends Expression<V>> lte(Expression<V> value)
```
    Description copied from interface: Conditional
    
    Applies the less than or equal to condition, equivalent to Conditional.lessThanOrEqual(Object).
    
    Specified by:
    
    lte in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - gte
```
public LogicalCondition<? extends Expression<V>,? extends Expression<V>> gte(Expression<V> value)
```
    Description copied from interface: Conditional
    
    Applies the greater than or equal to condition, equivalent to Conditional.greaterThanOrEqual(Object).
    
    Specified by:
    
    gte in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - in
```
public LogicalCondition<? extends Expression<V>,Collection<V>> in(Collection<V> values)
```
    Description copied from interface: Conditional
    
    Applies the in condition, checking if the condition is applicable to the values in the given collection.
    
    Specified by:
    
    in in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    values - to compare (non null)
    
    Returns:
    
    next query step
  - notIn
```
public LogicalCondition<? extends Expression<V>,Collection<V>> notIn(Collection<V> values)
```
    Description copied from interface: Conditional
    
    Applies the not in condition, checking if the condition is not applicable to the values in the collection.
    
    Specified by:
    
    notIn in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    values - to compare (non null)
    
    Returns:
    
    next query step
  - in
```
public LogicalCondition<? extends Expression<V>,? extends Return<?>> in(Return<?> query)
```
    Description copied from interface: Conditional
    
    Applies the equal condition
    
    Specified by:
    
    in in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    query - nested inner query (non null)
    
    Returns:
    
    next query step
  - notIn
```
public LogicalCondition<? extends Expression<V>,? extends Return<?>> notIn(Return<?> query)
```
    Description copied from interface: Conditional
    
    Applies the equal condition
    
    Specified by:
    
    notIn in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    query - nested inner query (non null)
    
    Returns:
    
    next query step
  - isNull
```
public LogicalCondition<? extends Expression<V>,V> isNull()
```
    Description copied from interface: Conditional
    
    Applies the 'is null' condition
    
    Specified by:
    
    isNull in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Returns:
    
    next query step
  - notNull
```
public LogicalCondition<? extends Expression<V>,V> notNull()
```
    Description copied from interface: Conditional
    
    Applies the 'not null' condition
    
    Specified by:
    
    notNull in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Returns:
    
    next query step
  - like
```
public LogicalCondition<? extends Expression<V>,String> like(String expression)
```
    Description copied from interface: Conditional
    
    Applies the equal condition
    
    Specified by:
    
    like in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    expression - like expression
    
    Returns:
    
    next query step
  - notLike
```
public LogicalCondition<? extends Expression<V>,String> notLike(String expression)
```
    Description copied from interface: Conditional
    
    Applies the not like condition
    
    Specified by:
    
    notLike in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    expression - like expression
    
    Returns:
    
    next query step
  - between
```
public LogicalCondition<? extends Expression<V>,Object> between(V start,
                                                                V end)
```
    Description copied from interface: Conditional
    
    Applies the between condition
    
    Specified by:
    
    between in interface Conditional<LogicalCondition<? extends Expression<V>,?>,V>
    
    Parameters:
    
    start - starting value to compare to
    
    end - ending value to compare to
    
    Returns:
    
    next query step
  - equals
```
public boolean equals(Object obj)
```
    Overrides:
    
    equals in class Object
  - hashCode
```
public int hashCode()
```
    Overrides:
    
    hashCode in class Object

Class FieldExpression<V>

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

FieldExpression

Method Detail

getName

getExpressionType

getClassType

as

getAlias

asc

desc

abs

max

min

avg

sum

round

round

trim

trim

substr

upper

lower

function

equal

notEqual

lessThan

greaterThan

lessThanOrEqual

greaterThanOrEqual

equal

notEqual

lessThan

greaterThan

lessThanOrEqual

greaterThanOrEqual

eq

ne

lt

gt

lte

gte

eq

ne

lt

gt

lte

gte

in

notIn

in

notIn

isNull

notNull

like

notLike

between

equals

hashCode