Skip Ribbon Commands
Skip to main content

Laura Rogers @WonderLaura

:

Quick Launch

Laura Rogers @WonderLaura > Posts > The Text Filter Web Part – Without Having To Filter Exact Text
Hi everyone,
My blog now has a new URL!
You can now find me at http://www.wonderlaura.com
July 02
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.  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.

 

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.
Shane YoungNo presence information on 7/3/2010 10:56 PM

facabeza@gmail.com

Laura: I can follow you up to step 10. in 11 it doesnt show me "choose two column..."
Shane YoungNo presence information on 7/7/2010 10:38 AM

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
Shane YoungNo presence information on 7/12/2010 8:19 AM

Charley

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'. 
Shane YoungNo presence information on 7/15/2010 12:22 PM

Laura

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
Laura RogersNo presence information on 7/15/2010 11:44 PM

Bin

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.
Shane YoungNo presence information on 7/20/2010 4:22 PM

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] ?
Shane YoungNo presence information on 8/12/2010 4:13 AM

Laura

pstilgoe, No, it doesn't work that way.  Marc's comment was inaccurate.
Laura RogersNo presence information on 8/12/2010 9:23 AM

Margaret

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!
Shane YoungNo presence information on 8/12/2010 1:11 PM

Margaret

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.
Shane YoungNo presence information on 8/13/2010 8:51 AM

Margaret

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.
Shane YoungNo presence information on 8/13/2010 9:26 AM

Stan Q.

Are there any other workarounds to make it display all items by default?
Shane YoungNo presence information on 9/13/2010 9:40 AM

Laura

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.
Laura RogersNo presence information on 9/13/2010 10:21 AM

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.
Shane YoungNo presence information on 10/18/2010 1:40 PM

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
Shane YoungNo presence information on 10/18/2010 4:25 PM

Laura

jhersko, Sorry, I don't know the answer to that.
Laura RogersNo presence information on 10/23/2010 11:47 AM

@sharepointScot

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
Shane YoungNo presence information on 10/29/2010 11:06 AM

Laura

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.
Laura RogersNo presence information on 10/29/2010 12:38 PM

AK

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
Shane YoungNo presence information on 11/14/2010 12:25 PM

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.
Shane YoungNo presence information on 11/25/2010 9:49 AM

Laura

Brian, Here are the instructions for connecting web parts to each other.  Please let me know where you're getting stuck.
Laura RogersNo presence information on 11/30/2010 9:57 PM

Ulises

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-
Shane YoungNo presence information on 1/7/2011 2:34 PM

Steve C

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.
Shane YoungNo presence information on 2/2/2011 9:04 AM

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!
Shane YoungNo presence information on 2/4/2011 4:47 AM

Laura

Steve, SharePoint 2007 or 2010?  XSLT list view or data view web part?
Laura RogersNo presence information on 2/22/2011 10:58 AM

Adil

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.
Shane YoungNo presence information on 4/6/2011 7:11 AM

Pen Moor

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!)
Shane YoungNo presence information on 4/8/2011 3:36 PM

Laura

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!!
Shane YoungNo presence information on 4/21/2011 9:23 PM

Laura

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!!
Laura RogersNo presence information on 4/21/2011 9:23 PM

DS

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!
Shane YoungNo presence information on 4/27/2011 8:15 PM

nachiket

this is super cool. thanks and keep posting.  Regards,  Sharepoint User - Goa, India
Shane YoungNo presence information on 5/2/2011 1:38 AM

Champ

Laura I love you!!!!!! ^0^ You help my life. I can do it!! yeahh
Shane YoungNo presence information on 5/18/2011 7:33 AM

David

Hi Laura,  I'm stuck on step 4.  When I go to select Field Name, Comparison, and Value are all blank.  Any insight?
Shane YoungNo presence information on 5/18/2011 9:37 AM

nachiket

It is not required that The Query String Variable needs to be the exact name of the column that you’d like to filter.
Shane YoungNo presence information on 5/19/2011 6:55 AM

Sarah

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?
Shane YoungNo presence information on 5/22/2011 3:51 PM

nachiket

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
Shane YoungNo presence information on 5/26/2011 11:50 PM

Laura

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.
Laura RogersNo presence information on 5/27/2011 12:39 AM

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.
Shane YoungNo presence information on 5/30/2011 6:38 PM

Raj

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  
Shane YoungNo presence information on 6/6/2011 6:33 PM

Laura

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.
Laura RogersNo presence information on 6/22/2011 1:06 PM

Vinz

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!
Shane YoungNo presence information on 6/27/2011 7:46 AM

Dinesh

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!
Shane YoungNo presence information on 7/14/2011 7:32 AM

Laura

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.
Laura RogersNo presence information on 7/22/2011 5:55 PM

Jake

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
Shane YoungNo presence information on 9/7/2011 11:45 AM

Yvette Wyskochil

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.
Shane YoungNo presence information on 9/14/2011 9:46 AM

Laura

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?
Laura RogersNo presence information on 9/21/2011 9:33 PM

Rachel Garrett

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?
Shane YoungNo presence information on 10/3/2011 3:40 PM

Laura

Rachel, Everything's in the ribbon now in 2010.  So, the parameters button is in the ribbon.
Laura RogersNo presence information on 10/11/2011 11:51 AM

Srini

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.
Shane YoungNo presence information on 11/9/2011 10:31 AM

yami

no filter web parts in SP foundation?
Shane YoungNo presence information on 11/10/2011 11:00 PM

Renee

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!
Shane YoungNo presence information on 11/11/2011 10:42 AM

Laura

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.
Laura RogersNo presence information on 11/11/2011 8:24 PM

Renee

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
Shane YoungNo presence information on 11/14/2011 4:59 PM

Renee (again!)

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
Shane YoungNo presence information on 11/15/2011 3:41 PM

Renee

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
Shane YoungNo presence information on 11/15/2011 9:24 PM

Bruno Okamoto

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
Shane YoungNo presence information on 12/5/2011 10:56 AM

Alan

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.
Shane YoungNo presence information on 12/14/2011 3:22 PM

Kevin Dostalek

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
Shane YoungNo presence information on 12/15/2011 1:56 PM

Laura

Perfect Kevin!  Thanks! Alan... do what he said.  ;-)
Laura RogersNo presence information on 12/19/2011 9:52 AM

Jo C

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
Shane YoungNo presence information on 12/21/2011 5:04 PM

Laura

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".
Laura RogersNo presence information on 1/6/2012 3:05 PM

Charbel hajjar

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
 on 3/5/2012 4:41 AM

AlexBern

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.
 on 3/14/2012 8:54 AM

AlexBern

One solution for lazy ones: http://roxority.com/filterzen/
its free for basic textfilters.
 on 3/15/2012 5:54 AM

Laura

Thanks guys for the suggestions!
lauraNo presence information on 4/12/2012 9:51 PM

Öztürk

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!
 on 5/10/2012 3:20 AM

Öztürk

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.
 on 5/10/2012 4:40 AM

Tim Odel

Thanks Laura!  We loved it
 on 6/6/2012 5:49 PM

Laura

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.
lauraNo presence information on 6/13/2012 9:53 PM

Mark

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,
 on 6/15/2012 11:49 AM

Duke

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.
 on 6/23/2012 7:39 AM

Laura

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.
lauraNo presence information on 6/27/2012 10:05 PM

Rohit

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!

 on 7/20/2012 4:37 PM

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.
 on 7/31/2012 10:57 AM
​I have disabled any new comments on this, because my blog has moved to a new site.  Please go here: http://www.wonderlaura.com
RSS FeedFacebookYouTube
 

 Our Books for End Users