Query Element (List)

  • Article

Applies to: SharePoint Foundation 2010

Defines the query for a view.

<Query>  <Where>
    ...
    </Where>  <GroupBy>
    ...
    </GroupBy>
  <OrderBy>
    ...
    </OrderBy>
</Query>

Attributes

Attribute

Description

None

N/A

Child Elements

GroupBy, OrderBy, Where

Parent Elements

View

Occurrences

Minimum: 0

Maximum: 1

Example

The following example queries the Status field for cases where the value does not equal Completed or is null, returning the results according to a descending sort on the Modified field. The Where element contains an Or element to group the filters.

<Query>
  <OrderBy>
    <FieldRef Name="Modified" Ascending="FALSE"></FieldRef>
  </OrderBy>
  <Where>
    <Or>
      <Neq>
        <FieldRef Name="Status"></FieldRef>
        <Value Type="Text">Completed</Value>
      </Neq>
      <IsNull>
        <FieldRef Name="Status"></FieldRef>
      </IsNull>
    </Or>
  </Where>
</Query>

See Also

Concepts

Query Schema

Other Resources

List Views