Share via

IsNotNull Element

  • Article

The IsNotNull element is used in a query to return items that are not empty (Null).

Syntax

 <IsNotNull>
</IsNotNull>
Parent Elements Child Elements
And, Or FieldRef

Example

The following query returns cases where the field base type is 1, the ID field equals the Project field, and the Template field is not 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>
      <IsNotNull>
        <FieldRef Name="Template"></FieldRef>
      </IsNotNull>
    </And>
  </Where>
  <OrderBy>
    <FieldRef Name="Title"></FieldRef>
    <FieldRef Name="ID"></FieldRef>
  </OrderBy>
</Query>

See Also

IsNull

Query

Where