IsNull Element (Query)

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

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

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

Attributes

Attribute	Description
None	N/A

Child Elements

FieldRef, Value, XML

Parent Elements

And, Or, Where

Occurrences

Minimum: 0 Maximum: Unbounded

Example

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>

See Also

Reference

IsNotNull Element (Query)

Where Element (Query)