Question

ChrisHoll on Wed, 01 Dec 2010 18:43:08


I have a large SharePoint list and want to create a view the shows only rows where a particular column is blank.  I know there are some special values like [Today] and [Me].  Is there one for [Blank] or [Null]?  How can this be done?

Replies

Waqas Sarwar(MVP) on Wed, 01 Dec 2010 20:02:31


simple way, i tested, just create another view and set the filter on your particular column.

like in your list you have due date column, and you want to setup a view which only display the rows where due date was not entered.

simply leave the field as empty: due date > Is Equal to >> in the vlaue filed leave it as empty.

 

hope this help

thanks

-ws

ChrisHoll on Thu, 02 Dec 2010 08:17:25


That was the first thing I tried.  I set a filter on the text colum and chose "is equal to" and then left field blank.  When I click OK, I get:

  • The filter type you selected cannot be used with this field.  To filter fields that contain multiple lines of text, use the 'contains' or 'begins with' operators.  You cannot use the 'begins with' operator if rich HTML is allowed for the field.

If I use 'contains' and leave the field blank, none of the rows show up.  (I guess they all must contain a blank character somewhere.)

Other ideas?

Thanks.

Emir Liu on Fri, 03 Dec 2010 06:28:15


Hi ChrisHoll,

Is the column you use to filter the view a multiple lines of text type?

Please Convert it to XSLT Data View in SPD then Filter option (Select the column name IsNull) could be set in Common Data View Tasks.

For detail please check out this similar thread. http://social.technet.microsoft.com/Forums/en/sharepointadmin/thread/77e37df7-0286-4a30-8b67-03317eff63b7

Thanks.

ChrisHoll on Sat, 04 Dec 2010 00:52:09


Hi Emir,

> Is the column you use to filter the view a multiple lines of text type?

Yes, it is.  I'll look into converting it to XSLT, but I don't have SPD so I'm not sure how to do this.  I'm thinking of just putting in a string, like <Value needed> and then fliter on that.

Thanks,

Chris

Ginni Atul Sharma on Sat, 04 Dec 2010 11:36:33


Hi,

I have a solution for this but that also requires SPD. I am afraid that you cannot do this out of the box. You have to use some trick and that can be done using SPD.

Regards

Ginni [My SharePoint Blog ]

SleeplessInFortWorth on Thu, 11 Jul 2013 20:57:12


ModifyView>Filter>YourFieldName>Is Equal to>[Is Null]

Works everytime, all the time for me.

imrocky on Fri, 04 Jul 2014 08:31:41


try setting filter value for that column equal to as 'blank' (leave empty) .

it worked for my site.


Daniel_MMX on Mon, 12 Mar 2018 05:19:18


Thank you

michellejwater2 on Thu, 07 Mar 2019 20:46:04


this doesn't work on mine

jmatthies7 on Fri, 20 Dec 2019 17:45:59


Thank you!! This worked for me.