Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a list in which there is a people column. I used to be able to filter the list by empty values in the column, but that has abruptly stopped working. That is, normally, I should be able to click on the column header, select the value "(empty)", and return any items in which no value has been entered.

I've created new lists on the same site and been able to filter normally. I've also saved the list as a template, recreated it, and been able to filter normally. Additionally, my database team has not been able to find anything wrong.

Does anyone have any ideas as to what could be the cause, or (better) fix?

share|improve this question
If you delete (or hide) the web part you're using to display your list and recreate it, can you filter by empty? –  Aron Foster Nov 5 '13 at 23:50
Hey, Aron. I'm sorry for the late response. No, deleting/recreating/hiding the list view web parts has no effect on the ability to filter by empty. –  bgw Dec 2 '13 at 16:51
Sounds like you're going to have to spend some time reading and understanding the XSLT and XPath in your web part. You say that it works when you saved the list as a template, so you might be able to use that as a reference. If you want to post the web part code, I'd take a look at it. –  Aron Foster Dec 2 '13 at 18:19
I don't think this has anything to do with the web part(s). I have multiple web parts on various pages all over the site that display this list. They have been up for over a year. None of them filters empty values correctly. To test, I dropped a new data view web part onto an empty .aspx page via SharePoint Designer. Same problem. –  bgw Dec 10 '13 at 23:05

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.