SharePoint 2010 Search list using OOTB Text filter Web Part

SharePoint 2010 Search list using OOTB Text filter Web Part

The SharePoint Text filter web part is simple to deploy as a search input for your SharePoint list or library view, you simply add it on your view’s page, connect it to your data view web part and choose the column to filter by, neat and easy, but the disadvantage of it all is that your search has to be exact and case sensitive which makes it not very useful.


The solution – follow this simple steps to configure your text filter with a little help from SharePoint Designer that make it work as a search box on your list view without the disadvantages described above:

  1. Open your site in SharePoint Designer –

  2. In SharePoint Designer go to Lists and Libaries and click on the list or library you wish to add a search view for –

  3. Create a new view for your list and call it “Search”.

  4. Click on your new view’s name in order to open it’s page in design mode –
  5. In desgin view click on the div above your list view, and then on the desginer ribbon go to the “insert” tab, click on the “web part” button, and choose to insert the “text filter” web part from the “filters” folder on to your page, just above your list view –

  6. Left click your list view and then look for the “Parameters” on the “List View Tools” options tab on your ribbon and click it –

  7. Create a new parameter, you can leave the default options and the default name value “param1” as is and click OK –

  8. Click the list view tools “Filter” button –

  9. Create a filter stating that the column you want to use as a search field contains your parameter –

  10. Right click your text filter web part and choose to add a connection –

  11. Choose “Send Filter Values To” from the combobox and click Next –

  12. Click next to connect to a web part on your page –

  13. Choose “Get Parameters From” as your target action and click next –

  14. Click the your parameter name and your text filter name and then click next –

  15. Click finish and then save your page –

  16. Open your page and search your column using partial text and uppercase or lowercase, you should anyway get search results.

  17. You can also create filters that are more complex, and search through a number of columns at once using this solution, hope you find this useful!

13 thoughts on “SharePoint 2010 Search list using OOTB Text filter Web Part

  1. I have one question…why doesn’t it display all the list items when the filter field is blank? My list appears empty until a string is entered in the filter field.

    Thanks!!

    • Hi Rick, thanks for your reply, that’s the filter behavior, a possible workaround could be to give your parameter a default value,
      Which could be a letter or a sign contained in all of the target field value’s.

      • I am using the text filter on a 10-digit serial number (field is formatted as text) in a web part list view. there isn’t a specific character that could be ‘defaulted’ that would return all the items in the list. Do you have any suggestions for what I could to get the list to display all items in the list view until the filter criteria are applied?

        Thank you!
        Tracy

  2. I have followed your guide step by step 5 times over and it’s still not working! No data is appearing in the list and when I type in text in the text web part nothing is displayed any tips?

  3. Could this search option be utilized more than once for a single list?

    For example, search by Title OR Created by Or any other column? If this is possible, how would you set it up?

    Thanks!

  4. It looks like the Text Filter is only available if you have an Enterprise License. Unfortunately, we do not have an Enterprise License and I can’t seem to find these features available in my environment.

  5. Hi,

    This is only seraches the title and not…. the entire item right?

    do you have a solution that searches the entire oitem columns?

    thank you

    • A way to search many fields at once is to make a calculated field with all of the fields you want to search concatenated together and then use the parameter to search that field. To concatenate, create a new field, select “Calculated Field” and then start putting the fields together like: [Field1] & ” ” & [Field2]

  6. I’ve used this technique and it works well for SharePoint made lists. but I’m having problems with a list generated by an external Data source.

    I’ve a list of over 200 items (people’s contacts) I need the search feature for just this list, but using all the steps listed above it never works. It appears that every time I save it the filter placed on the external list disappears. Do you know of a solution that woks with out of the box SharePoint 2010?

  7. A way to search many fields at once is to make a calculated field with all of the fields you want to search concatenated together and then use the parameter to search that field. To concatenate, create a new field, select “Calculated Field” and then start putting the fields together like: [Field1] & ” ” & [Field2]

Leave a Reply

Your email address will not be published. Required fields are marked *

* Copy This Password *

* Type Or Paste Password Here *