List of report filter attributes is presented below.
Name | Type | Description |
"KLRPT_FLT_CONDITION" | paramInt | Condition, mandatory (paramInt), one of the following:
- 0 - Do not use filtration.
- 1 - Equal (report fields should be equal to the filter value).
- 2 - Not equal (report fields should not be equal to the filter value).
- 4 - Less than (report fields should be less than the filter value).
- 8 - Greater than (report fields should be greater than the filter value).
- 16 - NULL (report field should be NULL).
- 17 - Not NULL (report field should be not NULL).
- 0x20 - Value must be within specified interval (range). Uses KLRPT_FLT_VALUE as begin of interval and KLRPT_FLT_VALUE2 as end.
- 0x40 - For filters of type "For N days before now". As Time in seconds before Now. Number of seconds are placed in KLRPT_FLT_VALUE.
- 0x80 - Value belongs to the specified set of values. See KLRPT_FLT_ARR_VALUE.
- 0x81 - Value does not belong to the specified set of values. See KLRPT_FLT_ARR_VALUE.
|
"KLRPT_FLT_VALUE" | paramString | Filter value to be used with the condition. Required. |
"KLRPT_FLT_VALUE2" | paramString | Additional filter value to be used with the condition (depending on the condition type or column type). Optional |
"KLRPT_FLT_ARR_VALUE" | Array of any type | Filter values array to be used with the condition (depending on the condition type or column type). Optional |