filter - APEXlang Reference

`filter`

Parent: savedReport

Direct Properties:

Property	Type	Required	Default Value	Details
`type`	`enum`	Yes	`column`	data type=`string`; lov=`STATIC` Valid values: `column` `rowSearch` `rowExpression`
`search`	`string`	Yes		data type=`string`; maxLen=4000 Applies when`type = rowSearch`
`rowExpression`	`multiline string`	Yes		data type=`multiline string`; maxLen=4000 Applies when`type = rowExpression`
`column`	`string`	Yes		data type=`string`; maxLen=128 Applies when`type = column`
`operator`	`enum`	Yes	`=`	data type=`string`; lov=`STATIC` Valid values: `=` `!=` `>` `>=` `<` `<=` `between` `isNull` `isNotNull` `like` `notLike` `in` `notIn` `contains` `doesNotContain` `regexp` `isInTheLast` `isNotInTheLast` `isInTheNext` `isNotInTheNext` Applies when`type = column`
`value`	`string`	Yes		data type=`string`; maxLen=4000 Applies when`type = column`
`from`	`string`	Yes		data type=`string`; maxLen=1900 Applies when`type = column and operator = between`
`to`	`string`	Yes		data type=`string`; maxLen=1900 Applies when`type = column and operator = between`
`value`	`number`	Yes		data type=`number`; maxLen=22 Applies when`type = column and operator in (isInTheLast)type = column and operator in (isNotInTheLast)type = column and operator in (isInTheNext)type = column and operator in (isNotInTheNext)`
`unit`	`enum`	Yes		data type=`string`; lov=`STATIC` Valid values: `min` `hours` `days` `weeks` `months` `years` Applies when`type = column and operator in (isInTheLast)type = column and operator in (isNotInTheLast)type = column and operator in (isInTheNext)type = column and operator in (isNotInTheNext)`

Property Groups:

identification

Property	Type	Required	Default Value	Details
`name`	`string`	Yes		data type=`string`; maxLen=255 Applies when`type = rowExpression`

identification {
  name: value
}

advanced

Property	Type	Required	Default Value	Details
`staticId`	`string`	Yes		data type=`string`; maxLen=255
`enabled`	`boolean`	Yes	`true`	data type=`boolean`

advanced {
  staticId: value
  enabled: false
}

APEXlang Example

filter sample (
    type: column
    search: value
    rowExpression: ```
      value
    ```
    column: value
    operator: "="
    value: value
    from: value
    to: value
    unit: min
    identification {
        name: value
    }
    advanced {
        staticId: value
        enabled: false
    }
)