Where
Definição da configuração do objeto Where para construção de condições nas consultas com o recurso _db.form()
and
and(column: string) : Where
Description
Defines a condition with the conditional AND operator on the Where object.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| column | string | Column to which the condition will be applied. |
Return
( Where )
Current Where object.
and(where: Where) : Where
Description
Defines a second level conditions with the conditional AND operator on the Where object.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| where | Where | Where object of the next level. |
Return
( Where )
Current Where object.
contains
contains(value: java.lang.Object) : Where
Description
Relational operator that filters any occurrence that includes the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Object | Conditional value. |
Return
( Where )
Relational operator.
different
different(value: java.lang.Object) : Where
Description
Relational operator that filters any occurrence that differs from the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Object | Conditional value. |
Return
( Where )
Relational operator.
endsWith
endsWith(value: java.lang.Object) : Where
Description
Relational operator that filters any occurrence that ends with the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Object | Conditional value. |
Return
( Where )
Relational operator.
equal
equal(value: java.lang.Object) : Where
Description
Relational operator that filters any occurrence that is exact to the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Object | Conditional value. |
Return
( Where )
Relational operator.
equals
equals(value: boolean) : Where
Description
Relational operator that filters any occurrence that is exact to the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | boolean | Conditional value. |
Return
( Where )
Relational operator.
equals(value: java.lang.Number) : Where
Description
Relational operator that filters any occurrence that is exact to the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Number | Conditional value. |
Return
( Where )
Relational operator.
equals(arg0: java.lang.Object) : boolean
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| arg0 | java.lang.Object |
Return
( boolean )
equals(value: string) : Where
Description
Relational operator that filters any occurrence that is exact to the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | string | Conditional value. |
Return
( Where )
Relational operator.
equals(value: java.sql.Date) : Where
Description
Relational operator that filters any occurrence that is exact to the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.sql.Date | Conditional value. |
Return
( Where )
Relational operator.
equals(value: java.sql.Time) : Where
Description
Relational operator that filters any occurrence that is exact to the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.sql.Time | Conditional value. |
Return
( Where )
Relational operator.
equals(value: java.sql.Timestamp) : Where
Description
Relational operator that filters any occurrence that is exact to the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.sql.Timestamp | Conditional value. |
Return
( Where )
Relational operator.
equals(value: java.time.LocalDate) : Where
Description
Relational operator that filters any occurrence that is exact to the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.time.LocalDate | Conditional value. |
Return
( Where )
Relational operator.
equals(value: java.time.LocalDateTime) : Where
Description
Relational operator that filters any occurrence that is exact to the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.time.LocalDateTime | Conditional value. |
Return
( Where )
Relational operator.
equals(value: java.time.LocalTime) : Where
Description
Relational operator that filters any occurrence that is exact to the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.time.LocalTime | Conditional value. |
Return
( Where )
Relational operator.
equals(value: java.util.UUID) : Where
Description
Relational operator that filters any occurrence that is exact to the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.util.UUID | Conditional value. |
Return
( Where )
Relational operator.
getConditions
getConditions() : java.util.List<ConditionalOperator>
Description
Returns the other nested conditions of the object.
Return
( java.util.List )
The other nested conditions of the object.
getTable
getTable() : string
Description
Returns the name of the table to which the condition will be applied.
Return
( string )
The name of the table to which the condition will be applied.
greaterOrEqualsThan
greaterOrEqualsThan(value: java.lang.Object) : Where
Description
Relational operator that filters out any occurrence that is greater or equals than the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Object | Conditional value. |
Return
( Where )
Relational operator.
greaterThan
greaterThan(value: java.lang.Object) : Where
Description
Relational operator that filters out any occurrence that is greater than the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Object | Conditional value. |
Return
( Where )
Relational operator.
in
in(values: java.lang.Object[]) : Where
Description
Relational operator that filters any occurrence that is equal to any of the given patterns.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| values | java.lang.Object[] | Conditional values. |
Return
( Where )
Relational operator.
in(values: java.lang.Object) : Where
Description
Relational operator that filters any occurrence that is equal to any of the given patterns.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| values | java.lang.Object | Conditional values. |
Return
( Where )
Relational operator.
inRaw
inRaw(value: java.lang.Object) : Where
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Object |
Return
( Where )
lessOrEqualsThan
lessOrEqualsThan(value: java.lang.Object) : Where
Description
Relational operator that filters out any occurrence that is less or equals than the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Object | Conditional value. |
Return
( Where )
Relational operator.
lessThan
lessThan(value: java.lang.Object) : Where
Description
Relational operator that filters out any occurrence that is less than the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Object | Conditional value. |
Return
( Where )
Relational operator.
notContains
notContains(value: java.lang.Object) : Where
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Object |
Return
( Where )
notEndsWith
notEndsWith(value: java.lang.Object) : Where
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Object |
Return
( Where )
notEqual
notEqual(value: java.lang.Object) : Where
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Object |
Return
( Where )
notEquals
notEquals(value: java.lang.Object) : Where
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Object |
Return
( Where )
notIn
notIn(values: java.lang.Object[]) : Where
Description
Relational operator that filters any occurrence that is different any of the given patterns.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| values | java.lang.Object[] | Conditional values. |
Return
( Where )
Relational operator.
notIn(values: java.lang.Object) : Where
Description
Relational operator that filters any occurrence that is different any of the given patterns.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| values | java.lang.Object | Conditional values. |
Return
( Where )
Relational operator.
notStartsWith
notStartsWith(value: java.lang.Object) : Where
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Object |
Return
( Where )
or
or(column: string) : Where
Description
Defines a condition with the conditional OR operator on the Where object.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| column | string | Column to which the condition will be applied. |
Return
( Where )
Current Where object.
or(where: Where) : Where
Description
Defines a second level conditions with the conditional OR operator on the Where object.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| where | Where | Where object of the next level. |
Return
( Where )
Current Where object.
setConditions
setConditions(conditions: java.util.List<ConditionalOperator>) : Where
Description
Defines the other nested conditions of the object.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| conditions | java.util.List | The other nested conditions of the object. |
Return
( Where )
Current Where object.
setTable
setTable(tableName: string) : Where
Description
Defines the name of the table to which the condition will be applied.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| tableName | string | The name of the table to which the condition will be applied. |
Return
( Where )
Current Where object.
startsWith
startsWith(value: java.lang.Object) : Where
Description
Relational operator that filters any occurrence that starts with the given pattern.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| value | java.lang.Object | Conditional value. |
Return
( Where )
Relational operator.