Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

IsNotNull Element (Query)

Published: May 2010

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


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

Attribute

Description

None

N/A

Minimum: 0

Maximum: Unbounded

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>
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.