Conditional (requery API)

Type Parameters:

Q - result of applying the condition

V - value type

All Known Subinterfaces:

QueryAttribute<T,V>, QueryExpression<V>

All Known Implementing Classes:

Abs, AliasedExpression, AttributeBuilder, Avg, Case, Coalesce, Collate, CollectionAttributeBuilder, Count, FieldExpression, Function, ListAttributeBuilder, Lower, MapAttributeBuilder, Max, Min, NamedExpression, Now, ResultAttributeBuilder, Round, SetAttributeBuilder, Substr, Sum, Trim, Upper
```
public interface Conditional<Q,V>
```
Defines an interface for objects for which conditions can be applied to.

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method and Description
`Q`	`between(V start, V end)` Applies the between condition
`Q`	`eq(Expression<V> value)` Applies the equal condition, equivalent to `equal(Object)`.
`Q`	`eq(V value)` Applies the equal condition, equivalent to `equal(Object)`.
`Q`	`equal(Expression<V> value)` Applies the equal condition
`Q`	`equal(V value)` Applies the equal condition
`Q`	`greaterThan(Expression<V> value)` Applies the greater than condition
`Q`	`greaterThan(V value)` Applies the greater than condition
`Q`	`greaterThanOrEqual(Expression<V> value)` Applies the greater than or equal to condition
`Q`	`greaterThanOrEqual(V value)` Applies the greater than or equal to condition
`Q`	`gt(Expression<V> value)` Applies the greater than condition, equivalent to `greaterThan(Object)`.
`Q`	`gt(V value)` Applies the greater than condition, equivalent to `greaterThan(Object)`.
`Q`	`gte(Expression<V> value)` Applies the greater than or equal to condition, equivalent to `greaterThanOrEqual(Object)`.
`Q`	`gte(V value)` Applies the greater than or equal to condition, equivalent to `greaterThanOrEqual(Object)`.
`Q`	`in(Collection<V> values)` Applies the in condition, checking if the condition is applicable to the values in the given collection.
`Q`	`in(Return<?> query)` Applies the equal condition
`Q`	`isNull()` Applies the 'is null' condition
`Q`	`lessThan(Expression<V> value)` Applies the less than condition
`Q`	`lessThan(V value)` Applies the less than condition
`Q`	`lessThanOrEqual(Expression<V> value)` Applies the less than or equal to condition
`Q`	`lessThanOrEqual(V value)` Applies the less than or equal to condition
`Q`	`like(String expression)` Applies the equal condition
`Q`	`lt(Expression<V> value)` Applies the less than condition, equivalent to `lessThan(Object)`.
`Q`	`lt(V value)` Applies the less than condition, equivalent to `lessThan(Object)`.
`Q`	`lte(Expression<V> value)` Applies the less than or equal to condition, equivalent to `lessThanOrEqual(Object)`.
`Q`	`lte(V value)` Applies the less than or equal to condition, equivalent to `lessThanOrEqual(Object)`.
`Q`	`ne(Expression<V> value)` Applies the not equal condition, equivalent to `notEqual(Object)`.
`Q`	`ne(V value)` Applies the not equal condition, equivalent to `notEqual(Object)`.
`Q`	`notEqual(Expression<V> value)` Applies the not equal condition, maybe null, which is equivalent to `notNull()`
`Q`	`notEqual(V value)` Applies the not equal condition, maybe null, which is equivalent to `notNull()`
`Q`	`notIn(Collection<V> values)` Applies the not in condition, checking if the condition is not applicable to the values in the collection.
`Q`	`notIn(Return<?> query)` Applies the equal condition
`Q`	`notLike(String expression)` Applies the not like condition
`Q`	`notNull()` Applies the 'not null' condition

- Method Detail
  - equal
```
Q equal(V value)
```
    Applies the equal condition
    
    Parameters:
    
    value - to compare, maybe null, which is equivalent to isNull()
    
    Returns:
    
    next query step
  - notEqual
```
Q notEqual(V value)
```
    Applies the not equal condition, maybe null, which is equivalent to notNull()
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lessThan
```
Q lessThan(V value)
```
    Applies the less than condition
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - greaterThan
```
Q greaterThan(V value)
```
    Applies the greater than condition
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lessThanOrEqual
```
Q lessThanOrEqual(V value)
```
    Applies the less than or equal to condition
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - greaterThanOrEqual
```
Q greaterThanOrEqual(V value)
```
    Applies the greater than or equal to condition
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - eq
```
Q eq(V value)
```
    Applies the equal condition, equivalent to equal(Object).
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - ne
```
Q ne(V value)
```
    Applies the not equal condition, equivalent to notEqual(Object).
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lt
```
Q lt(V value)
```
    Applies the less than condition, equivalent to lessThan(Object).
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - gt
```
Q gt(V value)
```
    Applies the greater than condition, equivalent to greaterThan(Object).
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lte
```
Q lte(V value)
```
    Applies the less than or equal to condition, equivalent to lessThanOrEqual(Object).
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - gte
```
Q gte(V value)
```
    Applies the greater than or equal to condition, equivalent to greaterThanOrEqual(Object).
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - equal
```
Q equal(Expression<V> value)
```
    Applies the equal condition
    
    Parameters:
    
    value - to compare, maybe null, which is equivalent to isNull()
    
    Returns:
    
    next query step
  - notEqual
```
Q notEqual(Expression<V> value)
```
    Applies the not equal condition, maybe null, which is equivalent to notNull()
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lessThan
```
Q lessThan(Expression<V> value)
```
    Applies the less than condition
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - greaterThan
```
Q greaterThan(Expression<V> value)
```
    Applies the greater than condition
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lessThanOrEqual
```
Q lessThanOrEqual(Expression<V> value)
```
    Applies the less than or equal to condition
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - greaterThanOrEqual
```
Q greaterThanOrEqual(Expression<V> value)
```
    Applies the greater than or equal to condition
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - eq
```
Q eq(Expression<V> value)
```
    Applies the equal condition, equivalent to equal(Object).
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - ne
```
Q ne(Expression<V> value)
```
    Applies the not equal condition, equivalent to notEqual(Object).
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lt
```
Q lt(Expression<V> value)
```
    Applies the less than condition, equivalent to lessThan(Object).
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - gt
```
Q gt(Expression<V> value)
```
    Applies the greater than condition, equivalent to greaterThan(Object).
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - lte
```
Q lte(Expression<V> value)
```
    Applies the less than or equal to condition, equivalent to lessThanOrEqual(Object).
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - gte
```
Q gte(Expression<V> value)
```
    Applies the greater than or equal to condition, equivalent to greaterThanOrEqual(Object).
    
    Parameters:
    
    value - to compare
    
    Returns:
    
    next query step
  - in
```
Q in(Collection<V> values)
```
    Applies the in condition, checking if the condition is applicable to the values in the given collection.
    
    Parameters:
    
    values - to compare (non null)
    
    Returns:
    
    next query step
  - notIn
```
Q notIn(Collection<V> values)
```
    Applies the not in condition, checking if the condition is not applicable to the values in the collection.
    
    Parameters:
    
    values - to compare (non null)
    
    Returns:
    
    next query step
  - in
```
Q in(Return<?> query)
```
    Applies the equal condition
    
    Parameters:
    
    query - nested inner query (non null)
    
    Returns:
    
    next query step
  - notIn
```
Q notIn(Return<?> query)
```
    Applies the equal condition
    
    Parameters:
    
    query - nested inner query (non null)
    
    Returns:
    
    next query step
  - isNull
```
Q isNull()
```
    Applies the 'is null' condition
    
    Returns:
    
    next query step
  - notNull
```
Q notNull()
```
    Applies the 'not null' condition
    
    Returns:
    
    next query step
  - like
```
Q like(String expression)
```
    Applies the equal condition
    
    Parameters:
    
    expression - like expression
    
    Returns:
    
    next query step
  - notLike
```
Q notLike(String expression)
```
    Applies the not like condition
    
    Parameters:
    
    expression - like expression
    
    Returns:
    
    next query step
  - between
```
Q between(V start,
          V end)
```
    Applies the between condition
    
    Parameters:
    
    start - starting value to compare to
    
    end - ending value to compare to
    
    Returns:
    
    next query step

Interface Conditional<Q,V>

Method Summary

Method Detail

equal

notEqual

lessThan

greaterThan

lessThanOrEqual

greaterThanOrEqual

eq

ne

lt

gt

lte

gte

equal

notEqual

lessThan

greaterThan

lessThanOrEqual

greaterThanOrEqual

eq

ne

lt

gt

lte

gte

in

notIn

in

notIn

isNull

notNull

like

notLike

between