2.5.256 SxFT

Office

The SxFT structure specifies the pivot filter types.

Name

Value

Meaning

SXFTCOUNT

0x00000001

Specifies the "count" filter. This is a value filter.

SXFTPERCENT

0x00000002

Specifies the "percent" filter.  This is a value filter.

SXFTSUM

0x00000003

Specifies the "sum" filter. This is a value filter.

SXFTCAPTIONEQUALS

0x00000004

Specifies the "equals" filter.  This is a label filter.

SXFTCAPTIONDOESNOTEQUAL

0x00000005

Specifies the "not equal" filter. This is a label filter.

SXFTCAPTIONBEGINSWITH

0x00000006

Specifies the "begins with" filter. This is a label filter.

SXFTCAPTIONDOESNOTBEGINWITH

0x00000007

Specifies the "does not begin with" filter. This is a label filter.

SXFTCAPTIONENDSWITH

0x00000008

Specifies the "ends with" filter. This is a label filter.

SXFTCAPTIONDOESNOTENDWITH

0x00000009

Specifies the "does not end with" filter. This is a label filter.

SXFTCAPTIONCONTAINS

0x0000000A

Specifies the "contains" filter. This is a label filter.

SXFTCAPTIONDOESNOTCONTAIN

0x0000000B

Specifies the "does not contain" filter. This is a label filter.

SXFTCAPTIONISGREATERTHAN

0x0000000C

Specifies the "is greater than" filter. This is a label filter.

SXFTCAPTIONISGREATERTHANOREQUALTO

0x0000000D

Specifies the "is greater than or equal to" filter. This is a label filter.

SXFTCAPTIONISLESSTHAN

0x0000000E

Specifies the "is less than" filter for field captions. This is a label filter.

SXFTCAPTIONISLESSTHANOREQUALTO

0x0000000F

Specifies the "is less than or equal to" filter. This is a label filter.

SXFTCAPTIONISBETWEEN

0x00000010

Specifies the "is between" filter. This is a label filter.

SXFTCAPTIONISNOTBETWEEN

0x00000011

Specifies the "is not between" filter. This is a label filter.

SXFTVALUEEQUAL

0x00000012

Specifies the "value equal" filter. This is a value filter.

SXFTVALUENOTEQUAL

0x00000013

Specifies the "value not equal" filter. This is a value filter.

SXFTVALUEGREATERTHAN

0x00000014

Specifies the "value greater than" filter. This is a value filter.

SXFTVALUEGREATERTHANOREQUAL

0x00000015

Specifies the "value greater than or equal to" filter. This is a value filter.

SXFTVALUELESSTHAN

0x00000016

Specifies the "value less than" filter. This is a value filter.

SXFTVALUELESSTHANOREQUAL

0x00000017

Specifies the "value less than or equal to" filter. This is a value filter.

SXFTVALUEBETWEEN

0x00000018

Specifies the "value between" filter. This is a value filter.

SXFTVALUENOTBETWEEN

0x00000019

Specifies the "value not between" filter. This is a value filter.

SXFTDATEEQUALS

0x0000001A

Specifies the "equals" filter. This is a date filter.

SXFTDATEOLDERTHAN

0x0000001B

Specifies the "older than" filter. This is a date filter.

SXFTDATENEWERTHAN

0x0000001C

Specifies the "newer than" filter. This is a date filter.

SXFTDATEBETWEEN

0x0000001D

Specifies the "between" filter. This is a date filter.

SXFTDATETOMORROW

0x0000001E

Specifies the "tomorrow" filter. This is a date filter.

SXFTDATETODAY

0x0000001F

Specifies the "today" filter. This is a date filter.

SXFTDATEYESTERDAY

0x00000020

Specifies the "yesterday" filter. This is a date filter.

SXFTDATENEXTWEEK

0x00000021

Specifies the "next week" filter. This is a date filter.

SXFTDATETHISWEEK

0x00000022

Specifies the "this week" filter. This is a date filter.

SXFTDATELASTWEEK

0x00000023

Specifies the "last week" filter. This is a date filter.

SXFTDATENEXTMONTH

0x00000024

Specifies the "next month" filter. This is a date filter.

SXFTDATETHISMONTH

0x00000025

Specifies the "this month" filter. This is a date filter.

SXFTDATELASTMONTH

0x00000026

Specifies the "last month" filter. This is a date filter.

SXFTDATENEXTQUARTER

0x00000027

Specifies the "next quarter" filter. This is a date filter.

SXFTDATETHISQUARTER

0x00000028

Specifies the "this quarter" filter. This is a date filter.

SXFTDATELASTQUARTER

0x00000029

Specifies the "last quarter" filter. This is a date filter.

SXFTDATENEXTYEAR

0x0000002A

Specifies the "next year" filter. This is a date filter.

SXFTDATETHISYEAR

0x0000002B

Specifies the "this year" filter. This is a date filter.

SXFTDATELASTYEAR

0x0000002C

Specifies the "last year" filter. This is a date filter.

SXFTDATEYEARTODATE

0x0000002D

Specifies the "year-to-date" filter. This is a date filter.

SXFTDATEALLDATESINPERIODQUARTER1

0x0000002E

Specifies the "first quarter" filter. This is a date filter.

SXFTDATEALLDATESINPERIODQUARTER2

0x0000002F

Specifies the "second quarter" filter. This is a date filter.

SXFTDATEALLDATESINPERIODQUARTER3

0x00000030

Specifies the "third quarter" filter. This is a date filter.

SXFTDATEALLDATESINPERIODQUARTER4

0x00000031

Specifies the "fourth quarter" filter. This is a date filter.

SXFTDATEALLDATESINPERIODJANUARY

0x00000032

Specifies the "January" filter. This is a date filter.

SXFTDATEALLDATESINPERIODFEBRUARY

0x00000033

Specifies the "February" filter. This is a date filter.

SXFTDATEALLDATESINPERIODMARCH

0x00000034

Specifies the "March" filter. This is a date filter.

SXFTDATEALLDATESINPERIODAPRIL

0x00000035

Specifies the "April" filter. This is a date filter.

SXFTDATEALLDATESINPERIODMAY

0x00000036

Specifies the "May" filter. This is a date filter.

SXFTDATEALLDATESINPERIODJUNE

0x00000037

Specifies the "June" filter. This is a date filter.

SXFTDATEALLDATESINPERIODJULY

0x00000038

Specifies the "July" filter. This is a date filter.

SXFTDATEALLDATESINPERIODAUGUST

0x00000039

Specifies the "August" filter. This is a date filter.

SXFTDATEALLDATESINPERIODSEPTEMBER

0x0000003A

Specifies the "September" filter. This is a date filter.

SXFTDATEALLDATESINPERIODOCTOBER

0x0000003B

Specifies the "October" filter. This is a date filter.

SXFTDATEALLDATESINPERIODNOVEMBER

0x0000003C

Specifies the "November" filter. This is a date filter.

SXFTDATEALLDATESINPERIODDECEMBER

0x0000003D

Specifies the "December" filter. This is a date filter.

SXFTDATENOTEQUAL

0x0000003E

Specifies the "not equal" filter. This is a date filter.

SXFTDATEOLDEROREQUAL

0x0000003F

Specifies the "older than or equal to" filter. This is a date filter.

SXFTDATENEWEROREQUAL

0x00000040

Specifies the "newer than or equal to" filter. This is a date filter.

SXFTDATENOTBETWEEN

0x00000041

Specifies the "not between" filter. This is a date filter.

Show: