How do I set a List View to only display rows that have data in a certain column? The column's data I am testing on is alphanumeric. A logic that I assume should work is something like:

if (column_name.length > 0) then {

But I'm not sure how to make that happen when editing the List View.

I have set my List View to only show rows where "Created by" "is equal to" "[Me]", and that is working great.

  • Why don't you update the CAML Query for List View, instead playing with XSLT ? Commented Mar 31, 2014 at 5:44
  • @ArsalanAdamKhatri, where does it say he's playing with XSLT? :) Commented Mar 31, 2014 at 6:05
  • Yeah sorry guys - I'm a total Sharepoint n00b. I'm editing this List View in the standard web interface. I don't know any other way. Thanks Arsalan for the edit. I should've used the code input tags. Commented Mar 31, 2014 at 6:48
  • @RobertLindgren List View is an XSLT List View Web Part, isn't it ? Commented Mar 31, 2014 at 8:08
  • Or just a list view app added to a page (in which you can update the view or select all the views on the list) @ArsalanAdamKhatri Commented Mar 31, 2014 at 8:18

1 Answer 1


You can create a boolean calculated column which will check the length of the field value of particular column or whatevet correct logic is and then update boolean value. Then create a view to filter by the boolean field.

  • Sounds great. How do I do that? Commented Mar 31, 2014 at 7:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.