The Text Filter Web Part – Without Having To Filter Exact Text

This applies to both SharePoint 2007 and 2010.  In MOSS Enterprise, and the 2010 version of Enterprise.

UPDATE (3/14/16): If you are using SharePoint 2013 or SharePoint Online with Office 365, enterprise, you don’t need this solution.  This functionality is now built into every single list and library, with a cute little “Find” box at the top.

There is an out-of-box web part called the Text Filter Web Part.  Basically, when you put this web part on a page, and put a list or library web part on the same page, you then create a web part connection that sends the text typed in the box as a filter to one of the columns in the web part, like this:

ch5[38]

The name Molly Clark had to be typed in exactly.  So, if you typed “Molly”, this record would not come up.

People use the text filter web part when they just want to search a single column in a list or library.  Otherwise, you’d simply use the “Search” box at the top of the screen, choose “This List” or “This Site” and perform SharePoint searches that way.

One more note before I get into today’s solution:

If you’re making use of site columns in your lists, there’s a setting where you can specifically select which columns you do NOT want to be searchable on the site.  In Site Settings, click Searchable Columns.  Put check boxes in the NoCrawl column for the ones that shouldn’t be searchable.
ch5[40]

Here’s how to set up the text filter so that any partial word searches will work

One problem:  with this solution, I don’t think there’s a way to make the list automatically display all items by default before doing your filter.

So again, this involves a data view web part… and that “parameters” concept that I keep raving about.

  1. Go to a web part page, open it up in SharePoint Designer, and insert a text filter web part and a data view web part of any list or library.
  2. Click to select your list web part, click the Data View menu, and choose Parameters.
  3. Create a new parameter.  In the name column, it doesn’t matter what it’s called, let’s just call it FilterParam.  In the Parameter Source drop-down box, choose Query String.
    The Query String Variable needs to be the exact name of the column that you’d like to filter.
    image
  4. Click the Data View menu, and choose Filter.
    image
    The Field Name needs to be the name of the column you’re going to filter, and HERE’S THE TRICK: Form the Comparison, choose CONTAINS.  For the Value, choose the name of the parameter that you created at step 3.  Click OK.
  5. Right click on the Text Filter Web Part, and choose Web Part Properties.
  6. The Filter Name box is required.  Make something up.  If it’s going to be used to search the title field, you might want to call it something intuitive like “Search Title”.  There’s also a box in the Advanced Filter Options, to control the width in pixels.  Type in a width if you wouldn’t like the web part stretching across the entire page.  Click OK.
  7. Right click on the text filter web part, and choose Web Part Connections.
  8. Choose Send Filter Values to.  Click Next.
  9. Connect to a web part on this page.  Click Next.
  10. Target web part: choose the name of your list.  This part is important:  The target action needs to be Get Parameters From.  Click Next.
    image
  11. Click the name of the text filter on the left, and the name of your new parameter on the right.  Click Next.
    image
  12. Click Finish and save the web part page.

Try it out.  In the text filter, you can type any part of any word and hit enter.  It doesn’t take Boolean expressions or anything fancy like that, but it’s much more useful than having to type the text exactly.  Again, this is a solution that I just whipped up today, and can’t tell if there’s any way to make the web part show all items until you want to filter it.  Nothing obvious.  I guess if you need to have the whole list displayed, you can just insert a third web part on the page, as a full view of the list.

 

Advertisements

109 comments

  • Marc.Anderson@sympraxisconsulting.com

    Laura: If you want to show all items with no filter in place, add a second filter specifying FilterParam Equals “” and OR it with the first filter clause. M.

    Like

  • facabeza@gmail.com

    Laura: I can follow you up to step 10. in 11 it doesnt show me “choose two column…”

    Like

  • karel.hrubes@schwancosmetics.cz

    Laura: For me it does not work, I proceeded step by step and there is this error: When processing a file (/WebPartPages/…) Error Type ‘Microsoft.SharePoint.WebPartPages.TransformableFilterValuesToParametersTransformer’ does not have a public property named ‘ProviderFieldNames’ I have a Czech version – 1029, maybe it’s that? Thanks for Help

    Like

  • I have the same error as karel.hrubes. An error occurred during the processing of . Type ‘Microsoft.SharePoint.WebPartPages.TransformableFilterValuesToParametersTransformer’ does not have a public property named ‘ProviderFieldNames’.

    Like

  • Hi guys who are getting the error: Maybe try creating the web part connection in the browser instead of in SharePoint Designer. Also, here’s a post I found regarding that same error when done in SPD: http://msmvps.com/blogs/laflour/archive/2008/08/09/deploying-sharepoint-web-parts-as-a-part-of-pagelayouts-in-moss-2007.aspx

    Like

  • For MOSS 2007, the steps are good until step 6. The rest should be done in web browser (NOT in SharePoint Designer). Here are the steps: 7. in IE, go to the page to customize, e.g. http://www.yoursite.com/yourlist/yourpage.aspx 8. click Site Actions -> Edit Page 9. on Text Filter Web Part, click Edit -> Connections -> Send Filter Values To -> [Your List] 10. in Configure Connection — Webpage Dialog box -> for Consumer Field Name, choose FilterParam (the parameter setup in the Data View) -> click Finish button 11. click on Exit Edit Mode.

    Like

  • pstilgoe@hotmail.com

    “If you want to show all items with no filter in place, add a second filter specifying FilterParam Equals “” and OR it with the first filter clause. ” Does this work ? In the dropdown on the filter you dont have the option to choose the [FilterParam] ?

    Like

  • pstilgoe, No, it doesn’t work that way. Marc’s comment was inaccurate.

    Like

  • I really like this solution, but unfortunately I was not able to use it. I have multiple filter web parts (not all text filter) on one page, and while the solution worked well on one specific text filter web part, if I did not have something typed into the particular text filter web part then nothing would show up. For example, if I tried to use a choice filter web part, it would not show any results. I suspect this is linked to the inability to display the entire list automatically. I would be very interested if someone comes up with a solution for this!

    Like

  • One trick I did discover related to my last note – for my purposes, I wanted to put in a partial match for file names. What I did to fix the problem of no list items showing up by default/ having to always have a value in that spot for the rest of my search filters to work is I set a default value for the filter. In this case, my default value is “.” because all file names will be something.doc, so this will match everything by default. The only issue is that is a user completely clears the field manually (doesn’t hit my “clear all” button) then it doens’t work.

    Like

  • Actually, if you set a default value for the filter that will be contained in every item – maybe it’s a space, maybe a “.” for file names – then it will display all items by default.

    Like

  • Are there any other workarounds to make it display all items by default?

    Like

  • Stan, As you can see in the comment above, Margaret has come up with a good idea. You can make the parameter’s default value just a space.

    Like

  • jhersko@gmail.com

    Laura, Using: SharePoint Server 2010; InfoPath 2010 Do you know if you can use promoted InfoPath text fields as the column source? I can’t get this to work and I’m not sure if it is because I’m doing something wrong, or if this solution can’t be applied to InfoPath promoted text fields.

    Like

  • jhersko@metrostarsystems.com

    Laura, I am working in a SharePoint Server 2010 environment. I am using SharePoint Designer 2010 and InfoPath 2010. I have a text field that I have promoted from InfoPath into a SharePoint library. I am trying to get the InfoPath promoted text field to accept partial searches via a text filter web part. can’t get this solution to work. Is this a limitation with InfoPath that you can’t use the parameter/filter options on a promoted field? I can set everything up, it just doesn’t work. Thanks, j

    Like

  • jhersko, Sorry, I don’t know the answer to that.

    Like

  • Hi Laura My problem is more than likely an easy fix. When clicking data view the Parameters is greyed out. Any idea what i’m missing? Thanks Frank

    Like

  • Hi Frank, I’ve never seen that happen. The only reason I can think of is if your cursor wasn’t inside the data view list.

    Like

  • Laura, The space does not seem to work as a default parameter value (it gets ignored). Any other common character seems to work. The “.” would be perfect for file names, but what if one is searching people’s full names? Here, a space would be perfect. I tried the filter web part itself as well (advanced options, default value) but did not work. Maybe JQuery would solve this (not that I know how to do it at this time). Thanks, AK

    Like

  • coughlanbrianm@gmail.com

    Hi Laura! I seem to have fallen at the first hurdle; I simply can’t work out how to connect the filter to the field I want to search. Any idea what the problem might be? Regards, Brian.

    Like

  • Brian, Here are the instructions for connecting web parts to each other. Please let me know where you’re getting stuck.

    Like

  • Hi Laura, My attempt worked out the first time without issues, and having the list not display on-load was actually part of the requirements -just wanted to say thanks for sharing the work-up-

    Like

  • In a list that contains a lot of (ie: Photos), if you have a field called “Keywords”, you can preset every item in the list to contain the keyword “All”, and the default search can be set for “All”. I was able to do this solely in the web interface in 2007.

    Like

  • steve.howlett@gmail.com

    Hi, I do not have the option to select “contains” in the DVWP filter! 😦 I have 8 options like is null, is not null etc Any ideas? Thanks!

    Like

  • Steve, SharePoint 2007 or 2010? XSLT list view or data view web part?

    Like

  • Hi everybody, My problem : after clearing text of filter i can’t see all values again. I have to refresh page te reload all items.

    Like

  • Thanks for the tip! FYI doesn’t quite work with grouping, but fine otherwise; and yes with SP 2010 you can do the connections in the browser. (BTW like the way entering the date foils the spam bots – nice touch!)

    Like

  • Adil, I agree. I recommend just adding link or a button to the page that says something like “clear search”, which would just refresh the page. Pen, Thanks!!

    Like

  • Adil, I agree. I recommend just adding link or a button to the page that says something like “clear search”, which would just refresh the page. Pen, Thanks!!

    Like

  • Thank you for this. I was trying to get a “current user” filter to apply to an external list on a column that was a concatinated list of a number of user domain logins. This did the trick, and I didn’t have to go past step 5, as I already had the filter on the page and I knew how to configure it to pass a parameter. Thank you again!

    Like

  • this is super cool. thanks and keep posting. Regards, Sharepoint User – Goa, India

    Like

  • Laura I love you!!!!!! ^0^ You help my life. I can do it!! yeahh

    Like

  • Hi Laura, I’m stuck on step 4. When I go to select Field Name, Comparison, and Value are all blank. Any insight?

    Like

  • It is not required that The Query String Variable needs to be the exact name of the column that you’d like to filter.

    Like

  • I got this filter working perfectly but when I still can’t find a way to show all items. When I refresh the page I get the Retry button several times before the page reloads. Has anyone found a solution that shows all results?

    Like

  • Sarah, try following the same method mentioned my Laura using the Web browser, instead of Designer and you can see all users on page Load. nachiketkamat@hotmail.com

    Like

  • David, That sounds very strange, SPD doesn’t normally behave like that. Try on a different computer, apply updates, etc?? nachiket, Yep, thanks! I had just learned about query strings when I wrote this… I didn’t know.

    Like

  • Eduardo Bariquello

    Hi, Laura ! I have a question. How could I deploy this ? Let Give a example that what I´m saying. I create a webpart, so put this into a feature e compile into a wsp. In my case, I can´t do backup and restore on the client. Could give an Idea ? Tks in advance.

    Like

  • Thanks heaps for sharing this. I was on the verge of creating a custom filter unaware of this trick. I had a slightly different requirement and for the benefit of others, here’s what I needed: I had a list with a “Person Or Group” column that allows multiple values. I wanted to filter list items based on the current logged on user’s membership to this column. Since I cannot filter based on this column directly, I created a “List Workflow” which copies values entered into the “Person Or Group” column into a multiple lines text column. After this, I used your method with a twist, that is, I used a “Current User Filter Web Part”. After I got the filter hooked up with the List View Web Part, things just worked as I expected! For anyone looking for info on List Workflow, here is the one I came across – http://www.documentmanagementworkflowinfo.com/workflow/use-update-list-item-action-sharepoint-designer-workflow.htm

    Like

  • Eduardo, Sorry I don’t know. I’m not a developer, and usually just call a dev when I need something like that done… which is not very often.

    Like

  • Hi Laura, Thank a lot for this, exactly what I was looking for. Completed the data connection in the browser and works great. If anything the search seems to be case sensitive. Is there a way to avoid this? Thanks!

    Like

  • Hi Laura, I got stuck up at the starting itself, I couldnt find the TextFilterWebpart, I just did the following steps:- Site Action->Edit Page->Insert->Webpart, I couldn’t see that TextFilterWebpart over there(Even under List and Libraries & also in Categories), i googled it but still no solution. I even Can you please guide on this issue? Thank!

    Like

  • Dinesh, Do you have the enterprise version of the product? If so, maybe try looking in the site collection’s web part gallery to see if it’s in there at all. If you don’t have enterprise, you won’t have this web part.

    Like

  • Hi Laura, I have a question – when I insert a Data View Web Part on a page, the tab for the webpart shows WebPartPages:XsltListViewWebPart. Due to this, I do not see the Common Data View Tasks Menu when I right click the web part (since its an XsltListView Web Part instead of a DataView Web Part). So how do I get SPD to insert a DataView web part? Thanks in advance, Jake

    Like

  • This tutorial was so valuable to me. Thank you so much for publishing it! It worked beautifully. I have users who also want to be able to search using a document ID (text filter based on Name and using the exact name) as well as Subcategory. How do I set up something like that on the same page? Would I have to tie the other two searches to another copy of the forms library similar to what you showed us in this tutorial? The problem I’m currently having is that once I put the additional search options on the same page, my text filter gets messed up and won’t pull based on the FilterParam mentioned above.

    Like

  • Jake, Here’s a screencast I did about that: http://www.youtube.com/watch?v=r2eODYHp73A Yvette, Hmm, that sounds much more complicated. The only thing I can think of is to train the users to use sharepoint search on the list. I know that’s probably not what they want, though. If subcategory is a column, can’t they just click the column heading to filter that one?

    Like

  • I’m stuck at Step 2. I’m using SP/Designer 2010. I created a web part page, added a text filter web part, and added a data view web part. I selected the data view web part. However, I cannot find the “Data View” menu anywhere. Hint please?

    Like

  • Rachel, Everything’s in the ribbon now in 2010. So, the parameters button is in the ribbon.

    Like

  • First of all thank you very much. It helped me alot. I have a requirement. I need to filter a list using filter web parts. I will either choose a filter through Sharepoint list filter or enter a key word in Text filter. Is this something which is feasible with designer.

    Like

  • no filter web parts in SP foundation?

    Like

  • Thank you for this great tip. I tried it in our TEST environment and it worked like a charm. I took it a step further and created a new column that was a concatenation of all the other columns in the list (called it AllColumnValues) and then created the new parameter as QueryString: AllColumnValues. So, if “Molly” existed in any of the columns in the list, the Text Search returned those list items. However, now that I have it workding in TEST, I am leary of launching Sharepoint Designer 2010 in our PROD environment to replicate the same steps. I’m very confused about when it is safe to edit/not edit pages in Sharepoint Designer. I’ve read several posts about there being potential problems of doing this and that it is safest to launch SPD only in a QA/Development environment. To get around this, I did try to export the list and webpart to which I added the parameter and then, import it into PROD but the parameter did not come through. Any suggestions? Thanks again for all your great tips! Very helpful!

    Like

  • Srini, Yes. Just add the filter web part to the page, and then create a web part connection to your list. This web part connection can be created in either the browser or in SPD. Yami, Nope. Renee, I usually just create a blank web part page in production, and then open that page in SPD to create the data view web part. Then in the browser, export the web part. You can delete that temporary web part page. Then, cleanly import your web part onto your production homepage or wherever it’s supposed to be.

    Like

  • Thanks for the quick response, Laura! I (think) I followed your suggestion but am still having problems. I am SO CLOSE that I really want to get this to work! Here’s what I did: 1. I created a blank page and exported/imported the list (via “save as a template” & “create new list”) from production. 2. I opened up SPD 2010 and created the data view web part and set up the parameter and list filter. That all went smoothly. 3. I saved in SPD and tested the Text Filter Web Part/ Data View Web part on my blank page. They worked great! 4. I then exported the list from step #1 to my production page. That worked fine – the list came over. 5. HOWEVER, it was when I exported/ imported the Data View Web Part from my test blank page to my production page that I ran into problems. Upon import to production, I get the following error. (This error doesn’t make sense because I DO have the list. I even named the list by the same name!) ERROR List does not exist. The page you selected contains a list that does not exist. It may have been deleted by another user. Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: 47bbeaef-aa60-40c0-85fa-7177d37ec578 Date and Time: 11/14/2011 4:43:39 PM Any suggestions? At this point, what do I risk by editing my production page in SPD? Thanks a million … your posts are GREAT! – Renee

    Like

  • Hi Laura, I figured out a way to get around the “List does not exist” error. (So you can ignore my last post.) However, the filter and data view web parts imported from test (where they worked fine) do NOT work in production. All I can figure is that there are some dependencies (or something “under the hood”) that just will not import over. So at this point, my remaining option is to edit the production page directly in SPD (2010) so that I can add the data view web part from scratch on to that page. So, I come back to the question of “Am I risking anything / what is the downside of editing a production page in SPD?” Thanks SO MUCH for any advice you have! Renee

    Like

  • Laura, OK … 3 is a charm. I got your solution to work WITHOUT editing via SPD in production! So you can ignore all my posts! The “trick” was that that once I exported / imported my web part from within SPD, I had to go into the display view (in production) and re-type in the values for “Show Items Only When the Following is True.” Once I set that to “MultiColumn CONTAINS {SearchParm}”, it worked!! YEAH!!! SORRY to bother you so many times. Thanks for challenging me to think outside of the box (or the text box, I should say!) – Renee

    Like

  • Hi, Just one question… The max number of filter clauses you can specify is 10 (SP 2010)? Is there a “workaround” this limitation? thx, Bruno

    Like

  • OK, one more item to add to the list of questions. Has anyone been able to filter for a date range with this technique? I need all records after a specific date (date filter web part1) and before a specific date(date filter web part2), but how do I list the parameters both mentioning the same query string parameter, need it to be two different dates comming in.

    Like

  • Alan- Yes, I do that all the time (though I use an infopath form/webpart for the date range instead of 2 date filters… just so I can control the look/feel better, but it works the same). 1) Create 2 querystring parameters (StartDate, EndDate). 2) Create filters- DateFieldFromList, GreaterThanOrEqual, [StartDate] and DateFieldFromList, LessThanOrEqual, [EndDate]. 3) Make your 2 web part connections and use the “Get Parameters from” action to populate [StartDate] and [EndDate] from your filter webparts. 4) make sure you set defaults on your filter webparts– things won’t work right if they are blank/null

    Like

  • Perfect Kevin! Thanks! Alan… do what he said. 😉

    Like

  • Hi Laura From your note above – “Otherwise, you’d simply use the “Search” box at the top of the screen, choose “This List” or “This Site” and perform SharePoint searches that way.” Is it possible to combine a search box with some filters so the user could e.g filter on colour to look for all the widgets where colour = red with the free text search looking for anywhere in the library where widgets colour = red also have the word ‘computing’ for example. I am using SPS 2010 with filetr web parts added and it is a team site template with publishing enabled. Thanks Jo

    Like

  • Jo, Create a data view web part, and in the Design tab in sharepoint designer, check the box next to “sort and filter on headers”.

    Like

  • you can create instead of text Filter WebPart an HTML Form View WebPart that can be customized in the same way of text filter , in one difference that you can automatically display all items by default before doing any filter or SEARCH.
    Actually what we are do here is a filter and not a search .
    Charbel.hajjar@hotmail.com

    Like

  • HI everybody.

    After playing around with this textfilter reset problem I gave up. I’ve found a blogpost which helped me out:
    http://webdevshareetc.blogspot.com/2012/02/sharepoint-2010-filter-listlibrary-web.html

    I adapted some variables to fit it to my environment plus make search on library name colloumn available. see comment.

    Like

  • One solution for lazy ones: http://roxority.com/filterzen/
    its free for basic textfilters.

    Like

  • Thanks guys for the suggestions!

    Like

  • Hi, thanks for the informations.

    I followed KEVIN DOSTALEK’s steps for filtering the list in a date range. And I succeeded. The only problem is, when the date filter parameter is blank(first use), list isnt showed. And when some filter parameter is entered, true list items are shown.

    I had only one parameter, and I want to show greater than or equal to the entered date. I created 2 filters, one for the given parameter and the other one is for blank. I ORed them. But it didnt help.

    Thanks!

    Like

  • I decided to use a default value for the date to show the list for the first use.

    But now there is another problem. I have multiple filters (text,choice filters created in browser) and date filter(created in SP designer by filtering), I want all of them to work in cooperation.

    After entering some date for the date filter, list is filtered correctly but when I clear the date to release the list from date filter, list is not changed, still with the list items from the last date filter results…

    BTW, I’m just a beginner.

    Thanks.

    Like

  • Thanks Laura! We loved it

    Like

  • Ozturk,
    I’m afraid that with filters coming from all different directions, that’s not something that is going to be possible without delving into custom code or jQuery or something.

    Like

  • Hi Laura,
    I was watching you on Screencast and you mentioned at the end of some videos that you have more detailed information (step-by-step) in your blog. (Note: There are 34 wonderful Videos in WMV format such as 2010-02-01-ContentTypesFinal.camrec).

    Could you send me the link to those blogs? Please keep up the great work.

    Thank you so very much,

    Like

  • Hi Laura,
    You said “I’m afraid that with filters coming from all different directions, that’s not something that is going to be possible without delving into custom code or jQuery”

    Consider a list of companies. If I want my employees to be able filter this list by for example, every company that begins with S and is in Nebraska I have to custom develop?

    Should I be using a custom search page to achieve this?

    It seems like Sharepoint OOB stuff is always so limited. 😦

    Thank you Laura for your help in the community.

    Like

  • Duke,
    The regular built in search does have the “advanced search” page which you can customize. You can even customize all the list of specific properties on there. That may be the best route, instead of trying to reinvent the wheel. There’s a way to create a custom search and search results page that you could use just for that one site or list or whatever.

    Mark,
    Yes, the entire chapter 9 (about 70 pages) in my InfoPath book is dedicated to that exact solution.

    Like

  • Hi Laura!

    Your post is great but i am still unable to do keyword search using text filter webpart connected to Dataview webpart when i
    search by entering only partial word and it is also case-sensitive.

    The dataview webpart filter doesn’t seem to recognize “Contains” but rather processes only “Equals”.

    Thanks!

    Like

  • Francois aka Franske

    I have created a sort of work around on the issue how to show all items for a wildcard search with the text filter web part. Create a calculated column on the list (to be filtered). Add the Formula: [ColumnToSearch] & ” ” & *

    Configure in the text filter as default value *. And use the calculated column to filter. [CalculatedColumn] contains [FilterParam]. And create the connection as suggested.

    Like

  • Hi Rohit,
    You have to be sure to create this as a data view web part, and not an XSLT list view web part. So, when you insert the web part at the beginning, choose “empty data view” and THEN pick your list, instead of choosing your list from the data view drop down.

    Like

  • Hello Laura,
    Thanks for this demo.I got it to work.

    I’m trying to expand into the next step.
    I would like to provide a DropDown to the users that will allow them to search different columns rather than the column be ‘fixed’.

    I’m struggling with the terms on what to search for on how to learn.

    Do you have any examples I can look at?

    Thanks,
    Rocky Wiethorn

    Like

  • Balaji Vishwanath

    I Configured the Text Filter webpart with a Dataview webpart. Once the search is over, i cant able to edit or view the result item. Can anybody give me a solution?

    Like

  • Hi Laura,

    It seems like your solution only work with data view of a list. I created a data source which is a combined view of 3 lists and put it in the data view web part and the text filter only processed “Equal” not “contain”. i would appreciate If anyone can come up with a solution

    Like

  • Rocky,
    I don’t know how to do that with code. I’d look into the metadata navigation settings in your list/library settings. It sounds like it may fulfill your requirement.

    Tu,
    Yes, this is much harder if you’re using something other than a plain ol’ data view of one list. I don’t know the answer to your merged view question.

    Balaji,
    Sorry, I don’t understand your question. Is there a particular step you’re stuck at?

    Like

  • Hi Laura,

    I have always enjoyed and learned sth from your blogs!

    Is there a way/work around to use “contains” instead of “Equals” for lookup fields? There is no “Contains” option for lookup fields in 2007.

    Thanks
    K

    Like

  • Thanks Laura you post really helped. You Saved the day for me

    Like

  • Amazing! When I first started developing in SharePoint it felt like pulling teeth but with AMAZING and HELPFUL tutorials like yours I can actually accomplish something useful to my organization.

    Thank you so much!

    Like

  • Fun Fact: You can’t use this method to filter lookup columns. Grrrr

    Great post Laura!

    Like

  • Thanks! It worked perfectly even though I’m not a Sharepoint Designer expert!!!

    Like

  • Laura, thanks for this solution. It worked for me. Appreciated.

    Like

  • Kume and Jordan,
    Unfortunately, lookup fields are really storing the ID of the item you pick, so even if you could use them, it would only be numbers that you’d be able to use to refer to any of those items.

    Like

  • Hi Laura,

    I have been trying to follow this post and implement it in Sharepoint 365. I keep running into difficulties. Could you please tell me if it is even possible to do this on sharepoint 365?

    If so, are any of the steps different?

    Thanks

    Like

  • Panicos,
    Do you have the new version of Office 365 that they just upgraded within the last couple of weeks? If so, you’ll notice that in SharePoint Designer 2013, the design view is gone now. Maybe that’s what you’re noticing that’s different? It would look different, but you can still do the functionality. Also, for step 3 you can choose “none” as your parameter source as well. It doesn’t have to be a query string. Otherwise, can you be more specific about what your difficulties are?

    Liked by 1 person

  • Hi Laura,
    My scenario is, i m using DVWP for displaying my records with pagination (5 records per page) and i m using text filter to filter those data’s.The problem is when i m in first page and enters the text in textfilter it shows the filtered records
    correctly, but when i m in 3 page and enters the filter text it is not showing the filtered results in the same page, instead it shows “There are no items to show in this view.” along with start link only. But actually results are in 1st page. For that i need to navigate to start page by clicking of Start link.Any Idea to get result page directly.

    Like

  • Hi Laura,
    My stakeholders want to limit the DVWP to showing 10 rows at a time. If I do a search and the item is not in the 10 items that were showing before the search, I get a blank area. However, if I click on the next page or right arrow the sought item is there. Reason being is that the search result consists of items that are on the 2nd page page.

    I’ve been trying to manipulate the XSLT, by setting a cookie when the user searches, then having the DVWP refer to the cookie value ‘Search=bool’. So that part is working. However, I’ve been trying to fake out the DVWP by setting $RowLimit=0 or $LastRow=100, to no avail. I’m stumped on this one and would appreciate any recommendations to disable paging if ‘Search=true’. Or perhaps there’s a property setting that I’m overlooking?

    Thanks!

    Like

  • Vinay and Peter,
    From what I can tell, your issues are the same. They sound very similar to me. I have never come across that, and I do not know of a solution, unfortunately.

    Liked by 1 person

  • Hi Laura,

    being a sharepoint dummy i however was able to implement your descibed solution of the partial match filter (thumbs up to your descibtion!). Now i came accross the same problem as decribed above, that i would like to show all results as a default and just then filter. Has there been found a solution in the meantime?

    Thank you.

    Liked by 1 person

  • Hi Laura
    I just couldnt get the ‘Contains’ in the filter criteria. I’m using a dataformwebpart. Is there anything Im doing wrong ?

    Vivek

    Like

  • Vivek,
    Did you see Rohit’s question above, and my answer?

    Annette,
    No, I don’t know of a way.

    Like

  • This works in SharePoint Designer 2013 only in a limited situation in my experience.

    If you use SP Designer to insert a DataView you get access to the List View Tools ribbon section. However, after you save the page (and have SP Designer reload the page after the server has made its’ changes) the List View Tools ribbon section is no longer available. You only get the web part tools.

    What is extra strange is that if I open a page that I last saved in SP Designer 2010, SP Designer 2013 will show the List View Tools section. But if opened a page where I added the webpart by editing the page in my webbrowser I don’t see the List View Tools. I have to delete the web part completely and add it back.

    Is anybody else seeing this?

    Like

  • Hi Laura

    Thank you for your wonderful blog posts.

    Allow me to offer a solution / workaround to show all items when the filter is empty:

    Have two web part provide parameters to the list connection.
    Web part 1 is a Text Filter with the default value set to e.g. the letter E, made hidden by setting Chrome to None & Minimized.
    Web Part 2 is a HTML Form that the user will type their search words in.

    Both are then set to provide their values as parameters to the filter of the consumer list.
    When Web Part 2 is cleared / empty, Web Part 1 ensures that the list displays all the items that contains the default.

    For more details please see my blog post on the subject at
    http://jesper-simonsen.blogspot.dk/2013/11/searchlike-filtering-of-lists.html

    Thanks, Jesper

    Like

  • Hi, Thanks you for this tutorial it works really well. Just a question though if you have submitted a query then it return NULL how do you get it to go back to the default view. I have tried just submitting with an empty text field but it keeps the return from the last query submitted.

    Also is there anyway to style the form so that it has a button etc when I change the width and height it changes to like an iframe.

    Any help would be great.

    Thanks

    Like

  • Kyle,
    In the past, I’ve just put a little “refresh page” link so that end users can set it to blank, but they’re really just refreshing the page they’re on.

    Like

Leave a reply or question

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s