<dynamicFilter>
(Dynamic Filter)
This collection specifies dynamic filter criteria. These criteria are considered dynamic because they can change, either with the data itself (e.g., "above average") or with the current system date (e.g., show values for "today"). For any cells whose values do not meet the specified criteria, the corresponding rows shall be hidden from view when the fitler is applied.
<filterColumn colId="0"> <dynamicFilter type="today"/> </filterColumn>
Parent Elements |
---|
|
Attributes |
Description |
---|---|
|
A maximum value for dynamic filter. It shall be required for today, yesterday, tomorrow, nextWeek, thisWeek, lastWeek, nextMonth, thisMonth, lastMonth, nextQuarter, thisQuarter, lastQuarter, nextYear, thisYear, lastYear, and yearToDate. The above criteria are based on a value range. For example, if today's date is September 22nd, then the range for thisWeek is the values greater than or equal to September 17 and less than September 24. In the thisWeek range, the lower value is expressed using These dynamic filter shall not require Q1, Q2, Q3, Q4, M1, M2, M3, M4, M5, M6, M7, M8, M9, M10, M11 and M12. The above criteria shall not specify the range using These types of dynamic filters shall use aboveAverage and belowAverage The possible values for this attribute are defined by the XML Schema double datatype. |
|
Dynamic filter type, e.g., “today” or “nextWeek”. The possible values for this attribute are defined by the ST_DynamicFilterType simple type (§3.18.27). |
|
A minimum value for dynamic filter. See description of The possible values for this attribute are defined by the XML Schema double datatype. |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_DynamicFilter">
<attribute name="type" type="ST_DynamicFilterType" use="required"/>
<attribute name="val" type="xsd:double" use="optional"/>
<attribute name="maxVal" type="xsd:double" use="optional"/>
</complexType>