2.4.360 BrtDynamicRichFilter

The BrtDynamicRichFilter record specifies dynamic filter criteria associated with rich values. These criteria are considered dynamic because they can change, either with the data itself (for example, "above average") or with the current system date (for example, show values for "today"). For any cells whose values do not meet the specified criteria, the corresponding rows will be hidden from view when the filter is applied.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

cft

A

unused

xNumValue

...

...

xNumValueMax

...

...

key (variable)

...

cft (4 bytes): An unsigned integer that specifies the type of filter to be applied. This MUST be a value from the following table.

Value

Enumeration Name

Meaning

0x00000000

CFTNIL

No filter

0x00000001

CFTABOVEAVERAGE

Shows values that are above average.

0x00000002

CFTBELOWAVERAGE

Shows values that are below average.

0x00000008

CFTTOMORROW

Shows tomorrow’s dates.

0x00000009

CFTTODAY

Shows today’s dates.

0x0000000A

CFTYESTERDAY

Shows yesterday’s date.

0x0000000B

CFTNEXTWEEK

Shows next week’s dates.

0x0000000C

CFTTHISWEEK

Shows this week’s dates.

0x0000000D

CFTLASTWEEK

Shows last week’s dates.

0x0000000E

CFTNEXTMONTH

Shows next month’s dates.

0x0000000F

CFTTHISMONTH

Shows this month’s dates.

0x00000010

CFTLASTMONTH

Shows last month’s dates.

0x00000011

CFTNEXTQUARTER

Shows next quarter’s dates.

0x00000012

CFTTHISQUARTER

Shows this quarter’s dates.

0x00000013

CFTLASTQUARTER

Shows last quarter’s dates.

0x00000014

CFTNEXTYEAR

Shows next year’s dates.

0x00000015

CFTTHISYEAR

Shows this year’s dates.

0x00000016

CFTLASTYEAR

Shows last year’s dates.

0x00000017

CFTYEARTODATE

Shows the dates between the beginning of the year and today, inclusive.

0X00000018

CFTQ1

Shows the dates that are in the first quarter, regardless of year.

0x00000019

CFTQ2

Shows the dates that are in the second quarter, regardless of year.

0x0000001A

CFTQ3

Shows the dates that are in the third quarter, regardless of year.

0x0000001B

CFTQ4

Shows the dates that are in the fourth quarter, regardless of year.

0x0000001C

CFTM1

Shows the dates that are in January, regardless of year.

0x0000001D

CFTM2

Shows the dates that are in February, regardless of year.

0x0000001E

CFTM3

Shows the dates that are in March, regardless of year.

0x0000001F

CFTM4

Shows the dates that are in April, regardless of year.

0x00000020

CFTM5

Shows the dates that are in May, regardless of year.

0x00000021

CFTM6

Shows the dates that are in June, regardless of year.

0x00000022

CFTM7

Shows the dates that are in July, regardless of year.

0x00000023

CFTM8

Shows the dates that are in August, regardless of year.

0x00000024

CFTM9

Shows the dates that are in September, regardless of year.

0x00000025

CFTM10

Shows the dates that are in October, regardless of year.

0x00000026

CFTM11

Shows the dates that are in November, regardless of year.

0x00000027

CFTM12

Shows the dates that are in December, regardless of year.

A - fApplied (1 bit): A bit that specifies whether the range of the filter, as specified by the rfx field in the BrtBeginAFilter (section 2.4.8) record that begins the collection this record is a part of, has been calculated. A value of 1 specifies that the range of the filter has been calculated. A value of 1 also specifies that xNumValue and xNumValueMax are correctly calculated, if these values are not ignored. The value of fApplied MUST be 0 if cft is greater than or equal to 0x00000018 or equal to 0x00000000.

unused (7 bits): This value is undefined and MUST be ignored.

xNumValue (8 bytes): An Xnum (section 2.5.172) that specifies a value for the filter. For cft values greater than or equal to 0x00000008 and less than or equal to 0x00000017, this value specifies the minimum value in the range as specified by the rfx field in the BrtBeginAFilter (section 2.4.8) record that begins the collection of which this record is a part. For cft values of 0x00000001 or 0x00000002, this specifies the computed average. The value of xNumValue MUST be 0x00000000 and MUST be ignored unless cft is greater than or equal to 0x00000001 and less than or equal to 0x00000017.

xNumValueMax (8 bytes): An Xnum (section 2.5.172) that specifies the maximum value for this filter. This value MUST be 0x00000000 and MUST be ignored if cft is less than 0x00000008 or greater than 0x00000017.

key (variable): An XLWideString (section 2.5.169) that specifies the rich value key for which the filter is defined. This string MUST be less than or equal to 255 characters in length.