2.2.4.8 FilterInfo

  • Article

Namespace: http://schemas.datacontract.org/2004/07/Microsoft.Office.Access.SharedClient

Specifies how to filter a result set. The Expression and Text elements are complementary ways of filtering the result set. If both Expression and Text are specified by the protocol client and are not empty, the result set MUST only contain those rows that meet the conditions specified by both the Expression and Text elements. If only one of the Expression and Text elements is specified and non-empty, the result set MUST be filtered to only those rows that meet the conditions specified by that element. If both the Expression and Text elements are empty or not specified, then all rows from the result set MUST be returned by the protocol server.

 <xs:complexType name="FilterInfo" xmlns:xs="http://www.w3.org/2001/XMLSchema">
   <xs:sequence>
     <xs:element minOccurs="0" name="Culture" nillable="true" type="xs:string"/>
     <xs:element minOccurs="0" name="Expression" nillable="true" type="xs:string"/>
     <xs:element minOccurs="0" name="Fields" nillable="true" type="tns6:FieldList"/>
     <xs:element minOccurs="0" name="Text" nillable="true" type="xs:string"/>
   </xs:sequence>
 </xs:complexType>

Culture: A string ([XMLSCHEMA2] section 3.2.1) that specifies the culture name of the collation used to interpret any numbers, dates, or times specified in the Text element. MUST be formatted as specified by [RFC4646].

Expression: A string representing a CT_Expression ([MS-AXL2] section 2.2.3.1) that specifies conditions requested to be satisfied for every row of the result set.

Fields: A FieldList (section 2.2.4.44) that specifies which fields (2) in the result set are used when filtering using the Text element.

Text: A string ([XMLSCHEMA2] section 3.2.1) that specifies zero or more search terms requested to be present in every row of the result set in any of the fields (2) specified by the Fields element. This element is further specified as follows:

  • Multiple search terms MUST be separated by one or more space characters.

  • Search terms that contain a space character MUST be enclosed in double-quotes.

  • Search terms that are immediately preceded with the name of a field (2) specified by the Fields element followed by a colon (':') character (with no intervening space characters) are requested to be present in that specific field (2) in every row of the result set. Fields (2) specified as such that contain spaces MUST be surrounded by double-quotes.

If this element is specified and non-empty, the Fields and Culture elements MUST be specified and non-empty.