2.3.16 CT_Criteria

  • Article

Referenced by: CT_item

Criteria applied in a custom filter.

Attributes:

Type: Specifies the comparison operator applied between cell contents and the value attribute (2) during filtering.

Relation: If there are two criteria in the custom filter, the logical operator applied between them. If the parent CT_item element has two CT_Criteria elements, this attribute (2) MUST be set on the first CT_Criteria element in the CT_item. This attribute (2) MUST NOT be present on the last CT_Criteria element in the parent CT_item.

value: The value that is used with the relational operator defined in the Type attribute (2) for filtering.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

 <xs:complexType name="CT_Criteria">
   <xs:attribute name="Type" type="ST_enmAutoFilterCriteriaOperationType" default="EQ" use="optional"/>
   <xs:attribute name="Relation" type="ST_enmAutoFilterCriteriaRelationOperator" default="Nil" use="optional"/>
   <xs:attribute name="value" use="required" type="ST_value"/>
 </xs:complexType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).