Where Element (Query)

Article
10/20/2016

Applies to: SharePoint Foundation 2010

Used within the context of a query to specify a filter.

<Where>
</Where>

Attributes

Attribute	Description
None	N/A

Child Elements

And, BeginsWith, Contains, DateRangesOverlap, Eq, Geq, Gt, In, Includes, IsNotNull, IsNull, Leq, Lt, Membership, Neq, NotIncludes, Or

Parent Elements

Expr1, Expr2, Query

Occurrences

Minimum: 0

Maximum: 1

Remarks

The Where clause translates into the SQL SELECT statement. The format of the Where clause is a structured XML tree with a mixture of comparison operators, simple arithmetic operators, field (column) references, constant values, and predefined Collaborative Application Markup Language (CAML) constants.

Fields referenced in a Where element do not have to be fields of the primary list that is being queried. If a foreign list is being joined, then fields from the foreign list can be itemized in a ProjectedFields element and can then be referenced in the Where element.

Example

In the following example, the Where element uses the Geq element as the filter in the query, returning cases where the date and time value in the Expires field is greater than today's date and time.

<Query>
  <Where>
    <Geq>
      <FieldRef Name="Expires"/>
      <Value Type="DateTime">
        <Today/>
      </Value>
    </Geq>
  </Where>
  <OrderBy>
    <FieldRef Name="Modified"/>
  </OrderBy>
</Query>