filter
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | Yes | column | data type=string; lov=STATICValid values: column rowSearch |
search | string | Yes | data type=string; maxLen=4000Applies when type = rowSearch | |
column | reference | Yes | data type=reference; lov=COMPONENT; references=columnApplies when type = column | |
operator | enum | Yes | equals | data type=string; lov=STATICValid values: equals notEquals greaterThan greaterThanOrEquals lessThan lessThanOrEquals isEmpty isNotEmpty in notIn between notBetween contains doesNotContain startsWith doesNotStartWith matchesRegexp inTheLast notInTheLast inTheNext notInTheNextApplies when type = column |
value | string | Yes | data type=string; maxLen=4000Applies when type = column | |
from | string | Yes | data type=string; maxLen=1900Applies when type = column and operator in (between)type = column and operator in (notBetween) | |
to | string | Yes | data type=string; maxLen=1900Applies when type = column and operator in (between)type = column and operator in (notBetween) | |
value | number | Yes | data type=number; maxLen=22Applies when type = column and operator in (inTheLast)type = column and operator in (notInTheLast)type = column and operator in (inTheNext)type = column and operator in (notInTheNext) | |
unit | enum | Yes | data type=string; lov=STATICValid values: min hours days weeks months yearsApplies when type = column and operator in (inTheLast)type = column and operator in (notInTheLast)type = column and operator in (inTheNext)type = column and operator in (notInTheNext) | |
caseSensitive | boolean | Yes | false | data type=booleanApplies when type = rowSearchtype = column and operator in (contains)type = column and operator in (doesNotContain)type = column and operator in (startsWith)type = column and operator in (doesNotStartWith)type = column and operator in (matchesRegexp) |
advanced
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
enabled | boolean | Yes | true | data type=boolean |
advanced {
enabled: false
}APEXlang Example
filter sample (
type: column
search: value
column: @component
operator: equals
value: value
from: value
to: value
unit: min
caseSensitive: false
advanced {
enabled: false
}
)