Share via


Where Element

Within the Query element, the Where element is used to specify a filter for the view.

Syntax

<Where>
</Where>
Parent Elements Child Elements
Query And,Eq,Geq,Gt, Leq,Lt,Neq,Or,UserID

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 pre-defined (CAML) constants.

Example

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

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