This topic has not yet been rated - Rate this topic

Where Element (Query)

SharePoint 2010

Other Versions

Windows SharePoint Services 3

Published: May 2010

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

Copy


<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.

XML

Copy

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

Change History

Date	Description	Reason
May 2010	Initial publication

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ

How to refernce projectedfields from foreign list in where element

Could anybody please explain me by example how to reference fields from the foreign list in a ProjectedFields element and How can I referenced in the Where element???

History

8/3/2011
KhushiSShaikh