.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Unable to Clear Filter on SharePoint List

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :SharePoint

Hi all,

  How on earth do we clear the radio button filter that appears along side a list webpart thats providing its row via connections to another list.

 Here is my scenario:


 List 1 : Col 1 , Col 2 , Col 3

 List 2:  Col A, Col 1, Col B

 I have Connected 'List 1' to 'List 2' with List 1 providing a row to List 2, and configured to match it by 'Col 1' . In page the filter works fine.

 But once selected the selection remains and there seems to be no way of clearing the selection .....even on refreshing the page or navigating away and returning to the page.....the filter doesnt go... any suggestions ?


 How to get an option like Clear selected Filter, or Show All ...



View Complete Post

More Related Resource Links

Clear Selected Filter on SharePoint List Filter / Choice Filter Webparts


Hi All,

   I am using a 'choice filter web part' and a 'Share Point List Filter web part' on a page to filter other web parts ( Lists / Data view web parts).

   The filters are working fine, but once a filter is selected there doesn't seem to be a way of showing all contents back ( that is clearing the selected filter) . The selected filter remains even if we refresh the page !!!

 Any suggestions as on how we can have the option of 'show all' or 'clear filter' for  Choice Filter web part .


Filter items with a date column with parameters start date and end date on a sharepoint list?

If I have alist with a view that has the columns Title, Status and Status Date and the view has some items. How Can I add a filter with two parameters, start date and end date, to only show records with status date equal to or greater than parameter start date and status date is less than or equal to parameter end date? This is a sharepoint online site and I can't create and deploy custom code, can use SPD though. Do I need to use SPD or is this something I can do in the list settings? Thanks in advance.   Edit: I had a look here http://www.endusersharepoint.com/2009/09/29/sharepoint-date-filter-filtering-a-list-by-greater-than-or-equal-to-date/ but I don't have the Date Filter web part.

Unable to add filter to a sharepoint DateTime Column

Hi ,I have a DateTime column in  a List. When I try to create a view the column doesnt appear in the folter Column List.When i create a calculated column out of the DateTime Column, the new calculated column appears in the Filter Column ListCan any one explain why?ThanksSrila

Unable to load External list in Sharepoint Foundation - error due to trial period expired

I've created an external content type and external list on Sharepoint Foundation. Everything is OK when creating and viewing these items in create mode in sharepoint designer. When trying to view the external list in the browser I get error message "Unable to display this Web Part..." When I opened the same list in the mobile view url I get a more descriptive error message: "The shim execution failed unexpectedly - The trial period for this product has expired.." I have read and followed the instruction related to this thread concerning expired trial period bug, and iisreseted the server after change but I still can't display the list. http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/644ab342-4eaa-468c-95c1-f345a4f65f26#644ab342-4eaa-468c-95c1-f345a4f65f26 Any ideas anyone??

SharePoint List Query Filter


I am writting an SSRS report where I am querying a SharePoint list and trying to filter the data through the CAML query.  In BIDS, the query returns data, but the filter where clause doesn't seem to be getting recognized as I get all of the data back.  The where clause does seems to work in the U2U CAML Query Builder tool.

Can anyone please give advice as to why my where clause isn't working?


   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
         <Parameter Name="listName">
                   <DefaultValue>Subscribe - Sales by Product Group - Wheel</DefaultValue>

How can I filter a Sharepoint 2007 libarry list based on current user login?


Hi all.

I would like to know how I can filter a SharePoint library list based on current user login.

Suppose I have created the followings:

1) A SharePoint form library containing bunch of uploaded InfoPath form data.

2) The InfoPath form template contains a promoted text field called "TargetUser" to store user domain login (ex: DOMAIN\JOE) and every InfoPath form file in the library has a valid domain name stored in the "TargetUser" field.

I have created a custom view for the form library and would like to filter this view so only items whose "TargetUser" field matches current user's login ID are displayed.

I went to Edit View page to customize the view and tried to use the [Me] function but I got a "Filter value is not a valid text string" message instead when clicking OK. Apparently [Me] returns a Person/Group data type and the filter cannot compare its value to that of "TargetUser".

I tried using text functions (ex: TEXT([Me],"") hoping to extract default string value from [Me]. The filter accepts the parameter without any error but the resulting fitlered list does not display any items at all.

I have googled this subject for hours but I have not found any solution.

It would be greatly appreciated if anyone can help me t

How to hide a SharePoint List Filter?



I would like to hide the Sharepoint List Filter. I want my customers to be able to set the filter once and then hide it. Currently they can close it but that removes the filter entirely. 

In the options for the ListFilter there is an "Allows Hide" option, but "Hide" never surfaces in the UI.


Filter SharePoint list based on ID and scope as Recursive in DataFormWebPart


The following is the code in the DataFormWebPart

<DataSources><SharePoint:SPDataSource runat="server" DataSourceMode="List" UseInternalName="true" UseServerDataFormat="true" selectcommand="&lt;View&gt;&lt;ViewFields&gt;&lt;FieldRef Name=&quot;ContentTypeId&quot;/&gt;&lt;FieldRef Name=&quot;Title&quot;/&gt;&lt;FieldRef Name=&quot;File_x0020_Type&quot;/&gt;&lt;FieldRef Name=&quot;RoutingEnabled&quot;/&gt;&lt;FieldRef Name=&quot;Category&quot;/&gt;&lt;FieldRef Name=&quot;Approach&quot;/&gt;&lt;FieldRef Name=&quot;Channel&quot;/&gt;&lt;FieldRef Name=&quot;Competency_x0020_Pillar&quot;/&gt;&lt;FieldRef Name=&quot;Contact&quot;/&gt;&lt;FieldRef Name=&quot;Cost&quot;/&gt;&lt;FieldRef Name=&quot;Cost_x0020_Description&quot;/&gt;&lt;FieldRef Name=&quot;Country&quot;/&gt;&lt;FieldRef Name=&quot;Editor_x0027_s_x0020_choice&quot;/&gt;&lt;FieldRef Name=&quot;Execution_x0020_Plan&quot;/&gt;&lt;FieldRef Name=&quot;External_x0020_Links&quot;/&gt;&lt;FieldRef Name=&quot;Issue&quot;/&gt;&lt;FieldRef Name=&quot;Lessons&quot;/&gt;&lt;FieldRef N

Unable to display this Web Part. Error while displaying External list in sharepoint website

I tried to create an external content type for a website and I got an error....here are the details of the steps I followed:

1. I created an team site in sharepoint server 2010.Nothing I added extra to the site.

2. Then I opened that site in sharepoint designer and created a new external data type.

this is an SQL server. I have a small database in my server, I added that as an external data type to this site.

3. I am able to add the database to my site.

4. Then I created an External List of type contact list as my database has article ID, author, data of creation etc.

5. This creation also sucessfull and when I clicked on create button , my external list appeared on the quick launch but it didn't displayed anything on the page it showed up the below error on the page.


Error Message :


Unable to submit data to SharePoint List


I have a custom sharepoint list and i clicked customize form and opened in infopath 2010

and modified the interface by placing a button and added this as a webpart,

when i click the button the data is loaded into the list, and immediately when i am clicking the button to enter the new values the new data is not getting updated,

onclick of button i have added a rule to submit data(Main data connection)

How do I filter a SharePoint list on blanks?

I have a large SharePoint list and want to create a view the shows only rows where a particular column is blank.  I know there are some special values like [Today] and [Me].  Is there one for [Blank] or [Null]?  How can this be done?

how to add report parameters to filter list data in a ssrs report for a SharePoint List



i am using SQl Server 2005 reporting services to generate reports from MOSS 2007 Lists.

I need to define a parameter in the report to filter the data repective to that parameter dynamically.

like: in moss list there are three fileds A, B and C and i want to define field A as the report parameter, whenever i select the value of field A then on "View report" value of field B and C pertaining to field A should be display in report.

I am able to add report parameters but not able to attach to the report so that filtering can work.

Please guide me with solution

Ready made List Types provided by SharePoint

SharePoint provides some out of the box List Types. Some of the most used ready made list types that SharePoint provides currently are listed below:

Export SharePoint List to Excel Spreadsheet Programmatically using C#

In SharePoint applications, Custom Lists are used to store business data and Document Libraries to store the documents. But for data manupulation and analysis, Microsoft Excel provides very rich features as compared to SharePoint Lists. That's why people still loves to work on Microsoft Excel Sheets.

Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).

How to add custom list entries to mysite's calendar in Sharepoint 2007 site?


I would like to know below things

(1) How to create MySite for one specific member with other or administrator's access?

(2) Scenario : Administrator have created one SP2007 site. now Administrator have created one calendar (Sample calendar). Administrator have added some entries in calendar. now one user entered in portal site ansd view the calendar and he click on MySite menu. so this sample calendar entries should enter in that user's mysite calendar. How this can be achieved?

Thanks in advance.
Regards, Praful Udade

Sharepoint Blog Post List Renaming in onet.xml


Ihave created a Site definition and added a Posts Listview in the same.

<View List="$Resources:core,lists_Folder;/$Resources:core,blogpost_Folder;" BaseViewID="10" WebPartZoneID="Left" WebPartOrder="1"/>

This list is created using my own schema.xml which i have copied from the Blog site template.

I wanted to rename the title of the list [not Title field] which is coming to be Posts right now.

Is there anyway to do it?

Any help appreciated


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend