Export (0) Print
Expand All

IsNull Element (Query)

Last modified: July 15, 2011

Applies to: SharePoint Foundation 2013 | SharePoint Server 2013

In this article
Attributes
Child Elements
Parent Elements
Occurrences

Used within a query to return items that are empty (Null).


<IsNull>
  <FieldRef Name = "Field_Name"/>
  <Value Type = "Field_Type"/>
  <XML />
</IsNull>

Attribute

Description

None

N/A

Minimum: 0

Maximum: Unbounded

The following query returns cases where the field base type is 1, the ID column equals the Project column, and the Template column is empty. Results are returned in ascending order by Title and then by ID.

<Query>
  <Where>
    <And>
      <And>
        <Eq>
          <FieldRef Name="BaseType"></FieldRef>
          <Value Type="Integer">1</Value>
        </Eq>
        <Eq>
          <FieldRef Name="Project"></FieldRef>
          <Value Type="Integer">
            <ProjectProperty Select="ID"></ProjectProperty>
          </Value>
        </Eq>
      </And>
      <IsNull>
        <FieldRef Name="Template"></FieldRef>
      </IsNull>
    </And>
  </Where>
  <OrderBy>
    <FieldRef Name="Title"></FieldRef>
    <FieldRef Name="ID"></FieldRef>
  </OrderBy>
</Query>
Show:
© 2014 Microsoft