This topic has not yet been rated - Rate this topic

IsNull Element (Query)

SharePoint 2013

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

And, Or, Where

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.

XML

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

Reference

IsNotNull Element (Query)

Where Element (Query)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD