Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

IsNotNull Element

SharePoint 2003

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

Syntax

<IsNotNull>
</IsNotNull>

Element Relationships

Parent Elements
And , Or

Example

The following query returns cases where the field base type is 1, the ID field equals the Project column, and the Template column 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>

Related Topics

Show:
© 2015 Microsoft