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.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.