FilterUnit
FilterUnit is used for defining the unit for which date filters are linked to.
| Type | Description |
|---|---|
| SECONDS | Filters by the second value |
| MINUTES | Filters by the minute value |
| HOURS | Filters by the hour value |
| DAY | Filters by day |
| WEEK | Filters by week |
| MONTH | Filters month |
| QUARTER | Filters by quarter |
| YEAR | Filters by year |
DatePeriodType
DatePeriodType defines how the predefined date period interacts with the data.
| Type | Description |
|---|---|
PREDEF_SINGLE_DATES | Specifies a period on a specific date |
PREDEF_BETWEEN_DATES | Specifies a period between two dates |
PREDEF_BETWEEN_TIMES | Specifies a period between two times |
CmdType
CmdType defines what type of calculation is being processed when building a predicate.
| Type | Description |
|---|---|
ADD_MIN | Add the minimum (non-negative) possible amount onto the value |
ADD_MAX | Add the maximum possible amount onto the value |
ADD_AMOUNT | Add a specified amount onto the value |
SET_MIN | Set the value to the minimum possible value |
SET_MAX | Set the value to the maximum possible value |
SET_AMOUNT | Set the value to the specified amount |
SET_QUARTER_START | Sets the current month to the start of the current quarter |
SET_QUARTER_END | Sets the current month to the end of the current quarter |
SET_FIN_QUARTER_START | Sets the current date to the start of the current financial quarter |
SET_FIN_QUARTER_END | Sets the current date to the end of the current financial quarter |
SET_FIN_YEAR_START | Sets the current date to the start of the financial year |
SET_FIN_YEAR_END | Sets the current date to the end of the financial year |
SET_WEEK_START | Sets the current day to the start of the week (Defaults to Sunday) |
SET_WEEK_END | Sets the current day to the end of the week (Defaults to Saturday) |