Where Element
Within the Query element, the Where element is used to specify a filter for the view.
Syntax
<Where>
</Where>
Related Elements
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>