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
List View
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.
Result into this
Tools used:
Rohan
Categories: CAML, List, SharePoint
CAML, List Views, SharePoint
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.”
Try doing greater than 0. I think I read some where how it translates to checking for null
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?