SharePoint Designer 2013 – How to modify List View web part filters and parameters

Date:May 30th, 2014 Author: Tags: , , ,
Category: Filter, FilterPoint Web Part, General, SharePoint Development, SharePoint Ideas Comments:18 ;

SharePoint Designer is especially useful for things like setting up complex filters and parameters for List View web parts like ‘wildcard’ searches and ‘before or after a date’ filters.

In SharePoint Designer 2013 (SPD 2013) the “Design View” was (controversially) removed so now it’s a little harder to use as you have to wade through some X/HTML soup. There is also a bit of a wicked bug that’s going to trip you up as well so in this post I am going to give a few tips on how get to the Parameters and Filters options in the ribbon menu.

SharePoint Desinger 2013 - Filter and Parameters

Note –this post is NOT a tutorial on how to use SharePoint Designer (its complex and worth a whole book in itself) but just a few tips for those already familiar with using SPD on how to do use the 2013 version. It won’t put back all you’ve lost, just allow you to access the Parameter & Filter options.

Missing Designer View and finding the List View Web Part

When you edit a page the most obvious difference in SPD 2013 is that you don’t get a Design View (the WYSIWYG view that allows you to see how the page will look whilst editing it). Instead you’ve only got the code view and you’re going to have to work through some angle bracket gibberish!

You’re looking for the code that defines the list view – it starts with <WebPartPages:XsltListViewWebPart and ends with </WebPartPages:XsltListViewWebPart> (pink in the pic here).

SharePoint Designer 2013 - how to find List View Web Part LVWP in code view

But save your eyes! Just search (CTRL+F) for XsltListViewWebPart! If the cursor is between the two XsltListViewWebPart tags then this is the same as clicking on the List in the old Design / Split view.

(If there are more than one List View on the page you will have to figure out which is which by the position of the web part in the page or look for the URL listed in TitleUrl, DetailLink or Url)

Getting the List View Tools options to show in the Ribbon

After putting the text cursor (or clicking) in the code that makes up the List View web part the ribbon should show the List View Tools option.

Except… there is a wicked bug in SPD 2013 at the time of writing that means the Ribbon doesn’t update to show the Options menu (unless you’ve turned off Server Rendering).

The trick (given to me by MdMazzotti) is to right click on XsltListViewWebPart then select Tag Properties and then click OK without clicking anythingSPD - Tag PropertiesYou will now have access to the List View Tools > Options ribbon and the Filter and Parameters button (see picture at the top of this page) SPD - Web Part Properties

You can view these steps in a video :-

Unable to display content. Adobe Flash is required.

Tags: , , ,

18 Responses to “SharePoint Designer 2013 – How to modify List View web part filters and parameters”

  1. John Nowlin says:

    Thanks, this was very helpful. I have followed these instructions and built my filter. In fact I put four [or] filters on the same page. The filters work as expected.

    One thing not working, is the sort on the column headings of the listview, if they are clicked on, to for instance sort one of the columns all of the data goes away and I have to close the browser before it will allow me to re-use the filter.

    Also, how to I allow the user to view all list if the filter boxes are blank?

    I appreciate your help,

    John Nowlin

  2. Ryan says:

    @John – not sure what the problem is re: the col headers and sorting but that has to a SharePoint ‘issue’ – only thing I can think off is to turn off that (its in list or view settings somewhere I think) and have have fixed sorting – perhaps multiple different pages and views if you need to sort different ways. Not great I admit.

    re: Show everything – I don’t know of a way to do that with the built in LVWP when you do something like this. Sorry!

  3. Rich says:

    Thank you for saving me from what could have been a horrible day. What an annoying little bug!!

  4. Faisal says:

    Thanks!! After long struggle your solution works. Thanks a lot for this post keep posting…;)

  5. Rujal Jariwala says:

    Really very helpful post.
    Here I am filtering data according to “Created By”. It works fine on page render but facing an issue that when I click on Sorting option.. it gives all the values exist in list. And clicking for filtering it gives all values in dropdown to filter. How can I put filter user specific.
    How can put filter on this values also.
    I am using XsltListViewWebPart tag.

  6. Sanket Shah says:

    This is really useful article, It helps me to find List view ribbon in SharePoint 2013.

    Thank you for sharing your knowledge.

  7. sameera says:

    Is this applicable in updated version of SPD 2013?

    It’s not working for me. In my case, When I right click inside the XsltListViewWebPart tag on Tag properties, I get a different context menu: Page Properties. After clicking OK nothing appears in the ribbon.
    Thank you

  8. C Scott says:

    I have the same issue, selecting the tag properties I get a page properties and after clicking OK nothing appears. I have done this before so I am wondering if it is an update to sharepoint at some point?

  9. Gunnar Lindquist says:

    Great! At last You’ve given me the key to solve my problem.
    Now I only have to insert my new List Web Part into 125 pages… You are truly a hero in my World!!

  10. Andy Parkes says:

    Thank you for this
    I thought I was going crazy!

    Had no problems initially working with the list view but after I came back to make changes when the options had gone I thought I’d broken my page!

    Much appreciated

  11. SJ says:

    Your article worked for me.

    Thanks 🙂

    Everything worked fine except Paging. when clicking for next page, nothing happened.

    What might be wrong. Do you have any suggestions for me that can help me.

    Thanks in Advance 🙂

  12. Alan says:

    Thanks for the article!
    the paging in list view not work when clicking next page 🙁
    someone has solved it?

  13. Jessica says:

    When I click Tag Properties, I get a page properties window not the ListProperties. Is there a resolution for this?

  14. Dayne says:

    Just an update. The bug still exist and you need to follow the steps to get the List View Tools to appear.

    Thank you for posting this!

  15. alex says:

    dear ryan
    too many thanks.
    hope you to be successful in every project.
    your article saved my 3 days of endless search.
    i think microsoft must pay people like you for their bugs.

  16. Gary says:

    All:

    If you are not able to access List View Tools even after right-clicking on the XsltListViewWebPart then select Tag Properties then do the following:

    1. Close SharePoint Designer
    2. Go back to your SharePoint site and view its current Design in Design Manager and ensure you are using the Seattle Site Layout and not Oslo.
    3. If you are using Olso then change it to Seattle.
    4. Open SharePoint Design and right-clicking on the XsltListViewWebPart then select Tag Properties and it should now work.

    I would like to thank my brain for first getting me into this mess by using Olso to implement MetroUI on my SP site and also for remembering that changing it to Seattle might make a differnce because…I mean why wouldn’t it we’re talking MicroSoft afterall.

  17. Jeff says:

    I was already on Seattle and the ribbon still doesn’t change for me.

  18. Ali says:

    After fighting for more than hour with SPD and searching on internet I finally stumbled upon this article which helped in finding out “Parameters” option in ribbon which was missing.
    I am amazed at Microsoft’s stupidity that this bug is not fixed even in 2021.

Leave a Reply

Anti-Spam Quiz: