Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

2.4.300 SXRng

Office

The SXRng record specifies properties for numeric grouping or date grouping of cache items in a grouping cache field, as specified by Grouping. The values of the fRangeGroup and fCalculatedField fields of the SXFDB record of this cache field MUST be 1 and 0, respectively.


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

A

B

C

unused

A - fAutoStart (1 bit):  A bit that specifies whether the source data is used to set the starting range value.

Value

Meaning

0

The starting range value is not recalculated from the source data on the next refresh.

1

The starting range value is recalculated from the source data on the next refresh.

B - fAutoEnd (1 bit):  A bit that specifies whether the source data is used to set the ending range value.

Value

Meaning

0

The ending range value is not recalculated from the source data on the next refresh.

1

The ending range value is recalculated from the source data on the next refresh.

C - iByType (3 bits):  An unsigned integer that specifies the grouping criteria.

If the value of the fNumField field of the SXFDB record of this cache field is 1, iByType specifies numeric grouping, as specified by Grouping. In this case, iByType MUST be 0 and this record MUST be followed by three SXNum records specifying the starting number, the ending number, and the interval size, respectively. Additionally, the ending number MUST be greater than or equal to the starting number.

If the value of the fNumField field of the SXFDB record of this cache field is 0, iByType specifies date grouping, as specified by Grouping. In this case, iByType MUST be greater than 0. Additionally, this record MUST be followed by two SXDtr records followed by one SXInt record specifying the starting date/time, the ending date/time, and the interval size, respectively. The ending date/time MUST be greater than or equal to the starting date/time. If this cache field corresponds to source data entities, the collection of sequences of records that conform to the SRCSXOPER rule in this cache field MUST contain only SXDtr and SxNil records.

iByType MUST be a value from the following table:

Value

Meaning

Restriction on the value of the catm field of the SXFDB record of this cache field, dictated by the value of iByType.

0

Group by numeric value.

No restriction.

1

Group by seconds.

MUST be 62.

2

Group by minutes.

MUST be 62.

3

Group by hours.

MUST be 26.

4

Group by days.

MUST be 368.

5

Group by months.

MUST be 14.

6

Group by quarters.

MUST be 6.

7

Group by years.

No restriction.

unused (11 bits):  Undefined and MUST be ignored.

Show:
© 2016 Microsoft