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 ? – Arsalan Adam Khatri Mar 31 '14 at 5:44
  • @ArsalanAdamKhatri, where does it say he's playing with XSLT? :) – Robert Lindgren Mar 31 '14 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. – Jayden Lawson Mar 31 '14 at 6:48
  • @RobertLindgren List View is an XSLT List View Web Part, isn't it ? – Arsalan Adam Khatri Mar 31 '14 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 – Robert Lindgren Mar 31 '14 at 8:18

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? – Jayden Lawson Mar 31 '14 at 7:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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