Home > CAML, List, SharePoint > Is Null Filter Condition for List Views

Is Null Filter Condition for List Views

I have always wondered why SharePoint List Views don’t have filters for  Is Null and Is Not Null when CAML Queries support it.

U2U CAML Creator

image

List View

image

Turns out it does. When you select “is equal to” and “is not equal to” and do not enter any text it generates “IS Null” and “Is Not Null” CAML Queries for the View.

 

image

Result into this

image

 

Tools used:

U2U CAML Builder

STRAMIT CAML Viewer

Rohan

Advertisements
Categories: CAML, List, SharePoint Tags: , ,
  1. Tyler
    April 3, 2009 at 7:06 pm

    Thanks. One problem I have with this is that there’s no way to do null when you’re dealing with dates. If you try leaving the space blank, it tells you “Filter value is not a valid date.”

    • bazztrap
      April 3, 2009 at 7:16 pm

      Try doing greater than 0. I think I read some where how it translates to checking for null

  2. Angela French
    January 4, 2010 at 8:28 pm

    I came across your post trying to find and answer to the Not Null filter. It still does not work for me. When I set the column to “is not equalt to” and leave the value field empty, I get “The filter type you selected cannot be used with this field….”
    My field is a multiline type. Anyone else experience this?

  3. October 17, 2011 at 11:52 am

    I just used it for a date field and it worked great. Date is not equal to…

  4. G
    February 10, 2012 at 12:25 pm

    Funnily i flipped it around as in went with blank as my first condition DATE = NULL in conjunction with (in my case an OR) the second condition DATE= greater than or equal to .. [Today] and it worked!!!!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: