<ST_PivotFilterType> (Pivot Filter Types)

This simple type defines filters that can be applied to PivotTables.

This simple type's contents are a restriction of the XML Schema string datatype.

The following are possible enumeration values for this type:

Enumeration Value

Description

<captionBeginsWith> (Caption Begins With)

Indicates the "begins with" filter for field captions.

<captionBetween> (Caption Is Between)

Indicates the "is between" filter for field captions.

<captionContains> (Caption Contains)

Indicates the "contains" filter for field captions.

<captionEndsWith> (Caption Ends With)

Indicates the "ends with" filter for field captions.

<captionEqual> (Caption Equals)

Indicates the "equal" filter for field captions.

<captionGreaterThan> (Caption Is Greater Than)

Indicates the "is greater than" filter for field captions.

<captionGreaterThanOrEqual> (Caption Is Greater Than Or Equal To)

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

<captionLessThan> (Caption Is Less Than)

Indicates the "is less than" filter for field captions.

<captionLessThanOrEqual> (Caption Is Less Than Or Equal To)

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

<captionNotBeginsWith> (Caption Does Not Begin With)

Indicates the "does not begin with" filter for field captions.

<captionNotBetween> (Caption Is Not Between)

Indicates the "is not between" filter for field captions.

<captionNotContains> (Caption Does Not Contain)

Indicates the "does not contain" filter for field captions.

<captionNotEndsWith> (Caption Does Not End With)

Indicates the "does not end with" filter for field captions.

<captionNotEqual> (Caption Not Equal)

Indicates the "not equal" filter for field captions.

<count> (Count)

Indicates the "count" filter.

<dateBetween> (Date Between)

Indicates the "between" filter for date values.

<dateEqual> (Date Equals)

Indicates the "equals" filter for date values.

<dateNewerThan> (Date Newer Than)

Indicates the "newer than" filter for date values.

<dateNewerThanOrEqual> (Date Newer Than or Equal To)

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

<dateNotBetween> (Date Not Between)

Indicates the "not between" filter for date values.

<dateNotEqual> (Date Does Not Equal)

Indicates the "does not equal" filter for date values.

<dateOlderThan> (Date Older Than)

Indicates the "older than" filter for date values.

<dateOlderThanOrEqual> (Date Older Than Or Equal)

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

<lastMonth> (Last Month)

Indicates the "last month" filter for date values.

<lastQuarter> (Last Quarter)

Indicates the "last quarter" filter for date values.

<lastWeek> (Last Week)

Indicates the "last week" filter for date values.

<lastYear> (Last Year)

Indicates the "last year" filter for date values.

<M1> (January)

Indicates the "January" filter for date values.

<M10> (Dates in October)

Indicates the "October" filter for date values.

<M11> (Dates in November)

Indicates the "November" filter for date values.

<M12> (Dates in December)

Indicates the "December" filter for date values.

<M2> (Dates in February)

Indicates the "February" filter for date values.

<M3> (Dates in March)

Indicates the "March" filter for date values.

<M4> (Dates in April)

Indicates the "April" filter for date values.

<M5> (Dates in May)

Indicates the "May" filter for date values.

<M6> (Dates in June)

Indicates the "June" filter for date values.

<M7> (Dates in July)

Indicates the "July" filter for date values.

<M8> (Dates in August)

Indicates the "August" filter for date values.

<M9> (Dates in September)

Indicates the "September" filter for date values.

<nextMonth> (Next Month)

Indicates the "next month" filter for date values.

<nextQuarter> (Next Quarter)

Indicates the "next quarter" for date values.

<nextWeek> (Next Week)

Indicates the "next week" for date values.

<nextYear> (Next Year)

Indicates the "next year" filter for date values.

<percent> (Percent)

Indicates the "percent" filter for numeric values.

<Q1> (First Quarter)

Indicates the "first quarter" filter for date values.

<Q2> (Second Quarter)

Indicates the "second quarter" filter for date values.

<Q3> (Third Quarter)

Indicates the "third quarter" filter for date values.

<Q4> (Fourth Quarter)

Indicates the "fourth quarter" filter for date values.

<sum> (Sum)

Indicates the "sum" filter for numeric values.

<thisMonth> (This Month)

Indicates the "this month" filter for date values.

<thisQuarter> (This Quarter)

Indicates the "this quarter" filter for date values.

<thisWeek> (This Week)

Indicates the "this week" filter for date values.

<thisYear> (This Year)

Indicate the "this year" filter for date values.

<today> (Today)

Indicates the "today" filter for date values.

<tomorrow> (Tomorrow)

Indicates the "tomorrow" filter for date values.

<unknown> (Unknown)

Indicates the PivotTable filter is unknown to the application.

<valueBetween> (Value Between)

Indicates the "Value between" filter for text and numeric values.

<valueEqual> (Value Equal)

Indicates the "value equal" filter for text and numeric values.

<valueGreaterThan> (Value Greater Than)

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

<valueGreaterThanOrEqual> (Value Greater Than Or Equal To)

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

<valueLessThan> (Value Less Than)

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

<valueLessThanOrEqual> (Value Less Than Or Equal To)

Indicates the "value less than or equal to" filter for text and numeric values

<valueNotBetween> (Value Not Between)

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

<valueNotEqual> (Value Not Equal)

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

<yearToDate> (Year-To-Date)

Indicates the "year-to-date" filter for date values.

<yesterday> (Yesterday)

Indicates the "yesterday" filter for date values.

Referenced By

<filter@type> (§3.10.1.33)

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_PivotFilterType">
	<restriction base="xsd:string">
	<enumeration value="unknown"/>
	<enumeration value="count"/>
	<enumeration value="percent"/>
	<enumeration value="sum"/>
	<enumeration value="captionEqual"/>
	<enumeration value="captionNotEqual"/>
	<enumeration value="captionBeginsWith"/>
	<enumeration value="captionNotBeginsWith"/>
	<enumeration value="captionEndsWith"/>
	<enumeration value="captionNotEndsWith"/>
	<enumeration value="captionContains"/>
	<enumeration value="captionNotContains"/>
	<enumeration value="captionGreaterThan"/>
	<enumeration value="captionGreaterThanOrEqual"/>
	<enumeration value="captionLessThan"/>
	<enumeration value="captionLessThanOrEqual"/>
	<enumeration value="captionBetween"/>
	<enumeration value="captionNotBetween"/>
	<enumeration value="valueEqual"/>
	<enumeration value="valueNotEqual"/>
	<enumeration value="valueGreaterThan"/>
	<enumeration value="valueGreaterThanOrEqual"/>
	<enumeration value="valueLessThan"/>
	<enumeration value="valueLessThanOrEqual"/>
	<enumeration value="valueBetween"/>
	<enumeration value="valueNotBetween"/>
	<enumeration value="dateEqual"/>
	<enumeration value="dateNotEqual"/>
	<enumeration value="dateOlderThan"/>
	<enumeration value="dateOlderThanOrEqual"/>
	<enumeration value="dateNewerThan"/>
	<enumeration value="dateNewerThanOrEqual"/>
	<enumeration value="dateBetween"/>
	<enumeration value="dateNotBetween"/>
	<enumeration value="tomorrow"/>
	<enumeration value="today"/>
	<enumeration value="yesterday"/>
	<enumeration value="nextWeek"/>
	<enumeration value="thisWeek"/>
	<enumeration value="lastWeek"/>
	<enumeration value="nextMonth"/>
	<enumeration value="thisMonth"/>
	<enumeration value="lastMonth"/>
	<enumeration value="nextQuarter"/>
	<enumeration value="thisQuarter"/>
	<enumeration value="lastQuarter"/>
	<enumeration value="nextYear"/>
	<enumeration value="thisYear"/>
	<enumeration value="lastYear"/>
	<enumeration value="yearToDate"/>
	<enumeration value="Q1"/>
	<enumeration value="Q2"/>
	<enumeration value="Q3"/>
	<enumeration value="Q4"/>
	<enumeration value="M1"/>
	<enumeration value="M2"/>
	<enumeration value="M3"/>
	<enumeration value="M4"/>
	<enumeration value="M5"/>
	<enumeration value="M6"/>
	<enumeration value="M7"/>
	<enumeration value="M8"/>
	<enumeration value="M9"/>
	<enumeration value="M10"/>
	<enumeration value="M11"/>
	<enumeration value="M12"/>
	</restriction>
</simpleType>