Field Summary | ||
---|---|---|
const Number | CAPTION_BEGINS_WITH | |
Indicates the "begins with" filter for field captions. | ||
const Number | CAPTION_BETWEEN | |
Indicates the "is between" filter for field captions. | ||
const Number | CAPTION_CONTAINS | |
Indicates the "contains" filter for field captions. | ||
const Number | CAPTION_ENDS_WITH | |
Indicates the "ends with" filter for field captions. | ||
const Number | CAPTION_EQUAL | |
Indicates the "equal" filter for field captions. | ||
const Number | CAPTION_GREATER_THAN | |
Indicates the "is greater than" filter for field captions. | ||
const Number | CAPTION_GREATER_THAN_OR_EQUAL | |
Indicates the "is greater than or equal to" filter for field captions. | ||
const Number | CAPTION_LESS_THAN | |
Indicates the "is less than" filter for field captions. | ||
const Number | CAPTION_LESS_THAN_OR_EQUAL | |
Indicates the "is less than or equal to" filter for field captions. | ||
const Number | CAPTION_NOT_BEGINS_WITH | |
Indicates the "does not begin with" filter for field captions. | ||
const Number | CAPTION_NOT_BETWEEN | |
Indicates the "is not between" filter for field captions. | ||
const Number | CAPTION_NOT_CONTAINS | |
Indicates the "does not contain" filter for field captions. | ||
const Number | CAPTION_NOT_ENDS_WITH | |
Indicates the "does not end with" filter for field captions. | ||
const Number | CAPTION_NOT_EQUAL | |
Indicates the "not equal" filter for field captions. | ||
const Number | COUNT | |
Indicates the "count" filter. | ||
const Number | DATE_BETWEEN | |
Indicates the "between" filter for date values. | ||
const Number | DATE_EQUAL | |
Indicates the "equals" filter for date values. | ||
const Number | DATE_NEWER_THAN | |
Indicates the "newer than" filter for date values. | ||
const Number | DATE_NEWER_THAN_OR_EQUAL | |
Indicates the "newer than or equal to" filter for date values. | ||
const Number | DATE_NOT_BETWEEN | |
Indicates the "not between" filter for date values. | ||
const Number | DATE_NOT_EQUAL | |
Indicates the "does not equal" filter for date values. | ||
const Number | DATE_OLDER_THAN | |
Indicates the "older than" filter for date values. | ||
const Number | DATE_OLDER_THAN_OR_EQUAL | |
Indicates the "older than or equal to" filter for date values. | ||
const Number | LAST_MONTH | |
Indicates the "last month" filter for date values. | ||
const Number | LAST_QUARTER | |
Indicates the "last quarter" filter for date values. | ||
const Number | LAST_WEEK | |
Indicates the "last week" filter for date values. | ||
const Number | LAST_YEAR | |
Indicates the "last year" filter for date values. | ||
const Number | M_1 | |
Indicates the "January" filter for date values. | ||
const Number | M_2 | |
Indicates the "February" filter for date values. | ||
const Number | M_3 | |
Indicates the "March" filter for date values. | ||
const Number | M_4 | |
Indicates the "April" filter for date values. | ||
const Number | M_5 | |
Indicates the "May" filter for date values. | ||
const Number | M_6 | |
Indicates the "June" filter for date values. | ||
const Number | M_7 | |
Indicates the "July" filter for date values. | ||
const Number | M_8 | |
Indicates the "August" filter for date values. | ||
const Number | M_9 | |
Indicates the "September" filter for date values. | ||
const Number | M_10 | |
Indicates the "October" filter for date values. | ||
const Number | M_11 | |
Indicates the "November" filter for date values. | ||
const Number | M_12 | |
Indicates the "December" filter for date values. | ||
const Number | NEXT_MONTH | |
Indicates the "next month" filter for date values. | ||
const Number | NEXT_QUARTER | |
Indicates the "next quarter" for date values. | ||
const Number | NEXT_WEEK | |
Indicates the "next week" for date values. | ||
const Number | NEXT_YEAR | |
Indicates the "next year" filter for date values. | ||
const Number | PERCENT | |
Indicates the "percent" filter for numeric values. | ||
const Number | Q_1 | |
Indicates the "first quarter" filter for date values. | ||
const Number | Q_2 | |
Indicates the "second quarter" filter for date values. | ||
const Number | Q_3 | |
Indicates the "third quarter" filter for date values. | ||
const Number | Q_4 | |
Indicates the "fourth quarter" filter for date values. | ||
const Number | SUM | |
Indicates the "sum" filter for numeric values. | ||
const Number | THIS_MONTH | |
Indicates the "this month" filter for date values. | ||
const Number | THIS_QUARTER | |
Indicates the "this quarter" filter for date values. | ||
const Number | THIS_WEEK | |
Indicates the "this week" filter for date values. | ||
const Number | THIS_YEAR | |
Indicate the "this year" filter for date values. | ||
const Number | TODAY | |
Indicates the "today" filter for date values. | ||
const Number | TOMORROW | |
Indicates the "tomorrow" filter for date values. | ||
const Number | UNKNOWN | |
Indicates the PivotTable filter is unknown to the application. | ||
const Number | VALUE_BETWEEN | |
Indicates the "Value between" filter for text and numeric values. | ||
const Number | VALUE_EQUAL | |
Indicates the "value equal" filter for text and numeric values. | ||
const Number | VALUE_GREATER_THAN | |
Indicates the "value greater than" filter for text and numeric values. | ||
const Number | VALUE_GREATER_THAN_OR_EQUAL | |
Indicates the "value greater than or equal to" filter for text and numeric values. | ||
const Number | VALUE_LESS_THAN | |
Indicates the "value less than" filter for text and numeric values. | ||
const Number | VALUE_LESS_THAN_OR_EQUAL | |
Indicates the "value less than or equal to" filter for text and numeric values. | ||
const Number | VALUE_NOT_BETWEEN | |
Indicates the "value not between" filter for text and numeric values. | ||
const Number | VALUE_NOT_EQUAL | |
Indicates the "value not equal" filter for text and numeric values. | ||
const Number | YEAR_TO_DATE | |
Indicates the "year-to-date" filter for date values. | ||
const Number | YESTERDAY | |
Indicates the "yesterday" filter for date values. |
Field Detail |
---|
CAPTION_BEGINS_WITH | |
const Number CAPTION_BEGINS_WITH |
CAPTION_BETWEEN | |
const Number CAPTION_BETWEEN |
CAPTION_CONTAINS | |
const Number CAPTION_CONTAINS |
CAPTION_ENDS_WITH | |
const Number CAPTION_ENDS_WITH |
CAPTION_EQUAL | |
const Number CAPTION_EQUAL |
CAPTION_GREATER_THAN | |
const Number CAPTION_GREATER_THAN |
CAPTION_GREATER_THAN_OR_EQUAL | |
const Number CAPTION_GREATER_THAN_OR_EQUAL |
CAPTION_LESS_THAN | |
const Number CAPTION_LESS_THAN |
CAPTION_LESS_THAN_OR_EQUAL | |
const Number CAPTION_LESS_THAN_OR_EQUAL |
CAPTION_NOT_BEGINS_WITH | |
const Number CAPTION_NOT_BEGINS_WITH |
CAPTION_NOT_BETWEEN | |
const Number CAPTION_NOT_BETWEEN |
CAPTION_NOT_CONTAINS | |
const Number CAPTION_NOT_CONTAINS |
CAPTION_NOT_ENDS_WITH | |
const Number CAPTION_NOT_ENDS_WITH |
CAPTION_NOT_EQUAL | |
const Number CAPTION_NOT_EQUAL |
COUNT | |
const Number COUNT |
DATE_BETWEEN | |
const Number DATE_BETWEEN |
DATE_EQUAL | |
const Number DATE_EQUAL |
DATE_NEWER_THAN | |
const Number DATE_NEWER_THAN |
DATE_NEWER_THAN_OR_EQUAL | |
const Number DATE_NEWER_THAN_OR_EQUAL |
DATE_NOT_BETWEEN | |
const Number DATE_NOT_BETWEEN |
DATE_NOT_EQUAL | |
const Number DATE_NOT_EQUAL |
DATE_OLDER_THAN | |
const Number DATE_OLDER_THAN |
DATE_OLDER_THAN_OR_EQUAL | |
const Number DATE_OLDER_THAN_OR_EQUAL |
LAST_MONTH | |
const Number LAST_MONTH |
LAST_QUARTER | |
const Number LAST_QUARTER |
LAST_WEEK | |
const Number LAST_WEEK |
LAST_YEAR | |
const Number LAST_YEAR |
M_1 | |
const Number M_1 |
M_2 | |
const Number M_2 |
M_3 | |
const Number M_3 |
M_4 | |
const Number M_4 |
M_5 | |
const Number M_5 |
M_6 | |
const Number M_6 |
M_7 | |
const Number M_7 |
M_8 | |
const Number M_8 |
M_9 | |
const Number M_9 |
M_10 | |
const Number M_10 |
M_11 | |
const Number M_11 |
M_12 | |
const Number M_12 |
NEXT_MONTH | |
const Number NEXT_MONTH |
NEXT_QUARTER | |
const Number NEXT_QUARTER |
NEXT_WEEK | |
const Number NEXT_WEEK |
NEXT_YEAR | |
const Number NEXT_YEAR |
PERCENT | |
const Number PERCENT |
Q_1 | |
const Number Q_1 |
Q_2 | |
const Number Q_2 |
Q_3 | |
const Number Q_3 |
Q_4 | |
const Number Q_4 |
SUM | |
const Number SUM |
THIS_MONTH | |
const Number THIS_MONTH |
THIS_QUARTER | |
const Number THIS_QUARTER |
THIS_WEEK | |
const Number THIS_WEEK |
THIS_YEAR | |
const Number THIS_YEAR |
TODAY | |
const Number TODAY |
TOMORROW | |
const Number TOMORROW |
UNKNOWN | |
const Number UNKNOWN |
VALUE_BETWEEN | |
const Number VALUE_BETWEEN |
VALUE_EQUAL | |
const Number VALUE_EQUAL |
VALUE_GREATER_THAN | |
const Number VALUE_GREATER_THAN |
VALUE_GREATER_THAN_OR_EQUAL | |
const Number VALUE_GREATER_THAN_OR_EQUAL |
VALUE_LESS_THAN | |
const Number VALUE_LESS_THAN |
VALUE_LESS_THAN_OR_EQUAL | |
const Number VALUE_LESS_THAN_OR_EQUAL |
VALUE_NOT_BETWEEN | |
const Number VALUE_NOT_BETWEEN |
VALUE_NOT_EQUAL | |
const Number VALUE_NOT_EQUAL |
YEAR_TO_DATE | |
const Number YEAR_TO_DATE |
YESTERDAY | |
const Number YESTERDAY |