FilterCriteria
A complex data type that describes the filter criteria for a query.
Schema
<xsd:complexType name="FilterCriteria">
<xsd:sequence>
<xsd:element name="Name" type="xsd:string"/>
<xsd:element name="Value" type="xsd:string"/>
<xsd:element name="Operation" type="xsd:string"/>
<xsd:element name="PromptFilterCriteria" type="xsd:boolean"/>
</xsd:sequence>
</xsd:complexType>
Elements
Name
The name of the filter.
Value
The operand to use.
Operation
The operator to use. The available operators vary according to the data type of the column.
Table 9‑2 describes the available operators and the data types to which each operator applies.
Table 9‑2 Filter criteria operators
Operator | Data types |
= | String, Integer, Double, Currency, DateTime, Boolean |
< | String, Integer, Double, Currency, DateTime, Boolean |
<= | String, Integer, Double, Currency, DateTime, Boolean |
> | String, Integer, Double, Currency, DateTime, Boolean |
>= | String, Integer, Double, Currency, DateTime, Boolean |
<> | String, Integer, Double, Currency, DateTime |
LIKE | String, Integer, Double, Currency, DateTime, Boolean |
NOT LIKE | String |
IN | String, Integer, Double, Currency, DateTime, Boolean |
IS NULL | String, Integer, Double, Currency, DateTime, Boolean |
IS NOT NULL | String, Integer, Double, Currency, DateTime, Boolean |
PromptFilterCriteria
Specifies whether the user can change filter criteria. If True, the user can change the filter criteria.