PivotFilterType

Inheritance: java.lang.Object

public final class PivotFilterType

Represents PivotTable Filter type.

Fields

FieldDescription
CAPTION_BEGINS_WITHIndicates the “begins with” filter for field captions.
CAPTION_BETWEENIndicates the “is between” filter for field captions.
CAPTION_CONTAINSIndicates the “contains” filter for field captions.
CAPTION_ENDS_WITHIndicates the “ends with” filter for field captions.
CAPTION_EQUALIndicates the “equal” filter for field captions.
CAPTION_GREATER_THANIndicates the “is greater than” filter for field captions.
CAPTION_GREATER_THAN_OR_EQUALIndicates the “is greater than or equal to” filter for field captions.
CAPTION_LESS_THANIndicates the “is less than” filter for field captions.
CAPTION_LESS_THAN_OR_EQUALIndicates the “is less than or equal to” filter for field captions.
CAPTION_NOT_BEGINS_WITHIndicates the “does not begin with” filter for field captions.
CAPTION_NOT_BETWEENIndicates the “is not between” filter for field captions.
CAPTION_NOT_CONTAINSIndicates the “does not contain” filter for field captions.
CAPTION_NOT_ENDS_WITHIndicates the “does not end with” filter for field captions.
CAPTION_NOT_EQUALIndicates the “not equal” filter for field captions.
COUNTIndicates the “count” filter.
DATE_BETWEENIndicates the “between” filter for date values.
DATE_EQUALIndicates the “equals” filter for date values.
DATE_NEWER_THANIndicates the “newer than” filter for date values.
DATE_NEWER_THAN_OR_EQUALIndicates the “newer than or equal to” filter for date values.
DATE_NOT_BETWEENIndicates the “not between” filter for date values.
DATE_NOT_EQUALIndicates the “does not equal” filter for date values.
DATE_OLDER_THANIndicates the “older than” filter for date values.
DATE_OLDER_THAN_OR_EQUALIndicates the “older than or equal to” filter for date values.
LAST_MONTHIndicates the “last month” filter for date values.
LAST_QUARTERIndicates the “last quarter” filter for date values.
LAST_WEEKIndicates the “last week” filter for date values.
LAST_YEARIndicates the “last year” filter for date values.
M_1Indicates the “January” filter for date values.
M_10Indicates the “October” filter for date values.
M_11Indicates the “November” filter for date values.
M_12Indicates the “December” filter for date values.
M_2Indicates the “February” filter for date values.
M_3Indicates the “March” filter for date values.
M_4Indicates the “April” filter for date values.
M_5Indicates the “May” filter for date values.
M_6Indicates the “June” filter for date values.
M_7Indicates the “July” filter for date values.
M_8Indicates the “August” filter for date values.
M_9Indicates the “September” filter for date values.
NEXT_MONTHIndicates the “next month” filter for date values.
NEXT_QUARTERIndicates the “next quarter” for date values.
NEXT_WEEKIndicates the “next week” for date values.
NEXT_YEARIndicates the “next year” filter for date values.
PERCENTIndicates the “percent” filter for numeric values.
Q_1Indicates the “first quarter” filter for date values.
Q_2Indicates the “second quarter” filter for date values.
Q_3Indicates the “third quarter” filter for date values.
Q_4Indicates the “fourth quarter” filter for date values.
SUMIndicates the “sum” filter for numeric values.
THIS_MONTHIndicates the “this month” filter for date values.
THIS_QUARTERIndicates the “this quarter” filter for date values.
THIS_WEEKIndicates the “this week” filter for date values.
THIS_YEARIndicate the “this year” filter for date values.
TODAYIndicates the “today” filter for date values.
TOMORROWIndicates the “tomorrow” filter for date values.
UNKNOWNIndicates the PivotTable filter is unknown to the application.
VALUE_BETWEENIndicates the “Value between” filter for text and numeric values.
VALUE_EQUALIndicates the “value equal” filter for text and numeric values.
VALUE_GREATER_THANIndicates the “value greater than” filter for text and numeric values.
VALUE_GREATER_THAN_OR_EQUALIndicates the “value greater than or equal to” filter for text and numeric values.
VALUE_LESS_THANIndicates the “value less than” filter for text and numeric values.
VALUE_LESS_THAN_OR_EQUALIndicates the “value less than or equal to” filter for text and numeric values.
VALUE_NOT_BETWEENIndicates the “value not between” filter for text and numeric values.
VALUE_NOT_EQUALIndicates the “value not equal” filter for text and numeric values.
YEAR_TO_DATEIndicates the “year-to-date” filter for date values.
YESTERDAYIndicates the “yesterday” filter for date values.

Methods

MethodDescription
equals(Object arg0)
getClass()
hashCode()
notify()
notifyAll()
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

CAPTION_BEGINS_WITH

public static final int CAPTION_BEGINS_WITH

Indicates the “begins with” filter for field captions.

CAPTION_BETWEEN

public static final int CAPTION_BETWEEN

Indicates the “is between” filter for field captions.

CAPTION_CONTAINS

public static final int CAPTION_CONTAINS

Indicates the “contains” filter for field captions.

CAPTION_ENDS_WITH

public static final int CAPTION_ENDS_WITH

Indicates the “ends with” filter for field captions.

CAPTION_EQUAL

public static final int CAPTION_EQUAL

Indicates the “equal” filter for field captions.

CAPTION_GREATER_THAN

public static final int CAPTION_GREATER_THAN

Indicates the “is greater than” filter for field captions.

CAPTION_GREATER_THAN_OR_EQUAL

public static final int CAPTION_GREATER_THAN_OR_EQUAL

Indicates the “is greater than or equal to” filter for field captions.

CAPTION_LESS_THAN

public static final int CAPTION_LESS_THAN

Indicates the “is less than” filter for field captions.

CAPTION_LESS_THAN_OR_EQUAL

public static final int CAPTION_LESS_THAN_OR_EQUAL

Indicates the “is less than or equal to” filter for field captions.

CAPTION_NOT_BEGINS_WITH

public static final int CAPTION_NOT_BEGINS_WITH

Indicates the “does not begin with” filter for field captions.

CAPTION_NOT_BETWEEN

public static final int CAPTION_NOT_BETWEEN

Indicates the “is not between” filter for field captions.

CAPTION_NOT_CONTAINS

public static final int CAPTION_NOT_CONTAINS

Indicates the “does not contain” filter for field captions.

CAPTION_NOT_ENDS_WITH

public static final int CAPTION_NOT_ENDS_WITH

Indicates the “does not end with” filter for field captions.

CAPTION_NOT_EQUAL

public static final int CAPTION_NOT_EQUAL

Indicates the “not equal” filter for field captions.

COUNT

public static final int COUNT

Indicates the “count” filter.

DATE_BETWEEN

public static final int DATE_BETWEEN

Indicates the “between” filter for date values.

DATE_EQUAL

public static final int DATE_EQUAL

Indicates the “equals” filter for date values.

DATE_NEWER_THAN

public static final int DATE_NEWER_THAN

Indicates the “newer than” filter for date values.

DATE_NEWER_THAN_OR_EQUAL

public static final int DATE_NEWER_THAN_OR_EQUAL

Indicates the “newer than or equal to” filter for date values.

DATE_NOT_BETWEEN

public static final int DATE_NOT_BETWEEN

Indicates the “not between” filter for date values.

DATE_NOT_EQUAL

public static final int DATE_NOT_EQUAL

Indicates the “does not equal” filter for date values.

DATE_OLDER_THAN

public static final int DATE_OLDER_THAN

Indicates the “older than” filter for date values.

DATE_OLDER_THAN_OR_EQUAL

public static final int DATE_OLDER_THAN_OR_EQUAL

Indicates the “older than or equal to” filter for date values.

LAST_MONTH

public static final int LAST_MONTH

Indicates the “last month” filter for date values.

LAST_QUARTER

public static final int LAST_QUARTER

Indicates the “last quarter” filter for date values.

LAST_WEEK

public static final int LAST_WEEK

Indicates the “last week” filter for date values.

LAST_YEAR

public static final int LAST_YEAR

Indicates the “last year” filter for date values.

M_1

public static final int M_1

Indicates the “January” filter for date values.

M_10

public static final int M_10

Indicates the “October” filter for date values.

M_11

public static final int M_11

Indicates the “November” filter for date values.

M_12

public static final int M_12

Indicates the “December” filter for date values.

M_2

public static final int M_2

Indicates the “February” filter for date values.

M_3

public static final int M_3

Indicates the “March” filter for date values.

M_4

public static final int M_4

Indicates the “April” filter for date values.

M_5

public static final int M_5

Indicates the “May” filter for date values.

M_6

public static final int M_6

Indicates the “June” filter for date values.

M_7

public static final int M_7

Indicates the “July” filter for date values.

M_8

public static final int M_8

Indicates the “August” filter for date values.

M_9

public static final int M_9

Indicates the “September” filter for date values.

NEXT_MONTH

public static final int NEXT_MONTH

Indicates the “next month” filter for date values.

NEXT_QUARTER

public static final int NEXT_QUARTER

Indicates the “next quarter” for date values.

NEXT_WEEK

public static final int NEXT_WEEK

Indicates the “next week” for date values.

NEXT_YEAR

public static final int NEXT_YEAR

Indicates the “next year” filter for date values.

PERCENT

public static final int PERCENT

Indicates the “percent” filter for numeric values.

Q_1

public static final int Q_1

Indicates the “first quarter” filter for date values.

Q_2

public static final int Q_2

Indicates the “second quarter” filter for date values.

Q_3

public static final int Q_3

Indicates the “third quarter” filter for date values.

Q_4

public static final int Q_4

Indicates the “fourth quarter” filter for date values.

SUM

public static final int SUM

Indicates the “sum” filter for numeric values.

THIS_MONTH

public static final int THIS_MONTH

Indicates the “this month” filter for date values.

THIS_QUARTER

public static final int THIS_QUARTER

Indicates the “this quarter” filter for date values.

THIS_WEEK

public static final int THIS_WEEK

Indicates the “this week” filter for date values.

THIS_YEAR

public static final int THIS_YEAR

Indicate the “this year” filter for date values.

TODAY

public static final int TODAY

Indicates the “today” filter for date values.

TOMORROW

public static final int TOMORROW

Indicates the “tomorrow” filter for date values.

UNKNOWN

public static final int UNKNOWN

Indicates the PivotTable filter is unknown to the application.

VALUE_BETWEEN

public static final int VALUE_BETWEEN

Indicates the “Value between” filter for text and numeric values.

VALUE_EQUAL

public static final int VALUE_EQUAL

Indicates the “value equal” filter for text and numeric values.

VALUE_GREATER_THAN

public static final int VALUE_GREATER_THAN

Indicates the “value greater than” filter for text and numeric values.

VALUE_GREATER_THAN_OR_EQUAL

public static final int VALUE_GREATER_THAN_OR_EQUAL

Indicates the “value greater than or equal to” filter for text and numeric values.

VALUE_LESS_THAN

public static final int VALUE_LESS_THAN

Indicates the “value less than” filter for text and numeric values.

VALUE_LESS_THAN_OR_EQUAL

public static final int VALUE_LESS_THAN_OR_EQUAL

Indicates the “value less than or equal to” filter for text and numeric values.

VALUE_NOT_BETWEEN

public static final int VALUE_NOT_BETWEEN

Indicates the “value not between” filter for text and numeric values.

VALUE_NOT_EQUAL

public static final int VALUE_NOT_EQUAL

Indicates the “value not equal” filter for text and numeric values.

YEAR_TO_DATE

public static final int YEAR_TO_DATE

Indicates the “year-to-date” filter for date values.

YESTERDAY

public static final int YESTERDAY

Indicates the “yesterday” filter for date values.

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int