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.
getConditions
getConditions() : java.util.List
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: [Ljava.lang.Object;[]) : Where
Description
Relational operator that filters any occurrence that is equal to any of the given patterns.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| values | [Ljava.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.
notIn
notIn(values: [Ljava.lang.Object;[]) : Where
Description
Relational operator that filters any occurrence that is different any of the given patterns.
Attributes
| NAME | TYPE | DESCRIPTION |
|---|---|---|
| values | [Ljava.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.
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) : 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.