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

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

Filter recurring events in Sharepoint

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :SharePoint
I have seen many people with the same problem but with no solution.

I am trying to show only the Calender events for the next 7 days, but creating a custom field and setting it to the Start Time and then filtering it doesnt work for recurring events since the recurring events are really only stored as one record ...

Any help will be appreciated.


View Complete Post

More Related Resource Links

SharePoint Recurring Events

I must be a dummy, but can't figure this out.  I am setting up a recurring event such as shown below in SharePoint WSS 3.0: Delivery Date - 11/10/2010; Start Time - 2 PM; End Time - 3 PM; Recurrence - Make this a repeating event; Pattern - Monthly and "The second Wednesday of every 1 month"; Date Range - Start Date of 11/10/2010; and End after 10 Occurrences. In the calendar, the event shows up on 11/10/2010, and in the data sheet view it has an end 8/10/2011.  There are no entries being shown in the calendar for any month other than Aug 2010. I wanted it to show up every month in the calendar between Nov 2010 and Aug 2011 at 2 PM on the second Wednesday.  What am I doing wrong?  

Any way to filter group or limit the view with recurring events??

It seems that recurring events (in Events view) cause greatlimitations in the views available. For example filtering or groupingon the start date of events does not work.I tried to use a calculated column that makes a 'Start Date' of theStart Time in order to filter on it, but the result is that only thefirst date of a series of a recurring task is shown, which of courseis useless.It seems that the Calendar view is the only way to limit views in day/week/etc.Did anyone else come up with an acceptable way to group or filterrecurring events?  Specifically filtering these recurring events by Week and Month.

Filter recurring Events


Has the capability to filter recurring events been added for sharepoint 2010? If so, does the Current Events view now work correctly for recurring events?

Office Space: Events in SharePoint 2007


Windows SharePoint Services (WSS) 3.0 provides a new and improved infrastructure for handling server-side events. In this installment of Office Space, we look at techniques for hooking up Before Events and After Events using both Features and code.

Ted Pattison

MSDN Magazine November 2007

create current user filter in sharepoint designer or wss3

hi, how can i create a current user filter in sharepoint designer?

Video: New and Improved Events in SharePoint 2010

In SharePoint 2010 SPListEventReceiver allows you to track events, including when a list is added; SPWebEventReceiver allows you to track Web events including webs being added and sites and webs being deleted. (Length: 9:22)

Video: SharePoint 2010 Workflows Events

This demonstration shows how to generate and use workflow event receivers. (Length: 2:25)

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.

SharePoint 2010 Mobile Page Filter Settings

hello, i want to know from where i can edit the mobile page "task" list filter settings ? thanks

How to Fire events on SharePoint DateTime Control in visual web part

Hi All, I am working on visual webpart of SharePoint 2010. I am using a <SharePoint:DateTimeControl> i m trying  to fire OnDateChanged event on it. I am not getting the Appropriate way to create the event. please help me out!!!!   void ToDate_OnDateChanged(object sender, EventArgs e)         {                         if (ToDate != null)             {                 DateTime min = Convert.ToDateTime(FromDate.SelectedDate.ToString());                 DateTime max = Convert.ToDateTime(ToDate.SelectedDate.ToString());                 int noofdays = Convert.ToInt32((max - min).TotalDays);                 txtNoOfDays.Text = noofdays.ToString();             }         }    <SharePoint:DateTimeControl runat="server" Calendar="Gregorian"  

Export Sharepoint Calendar (with Recurring) to Excel

Hi Everyone, I have a user who manages several Sharepoint calendars who likes to export lists and calendars to excel.  Currently when there is a recursive item, it only gets sent out once.  I have set up a list view that shows recurring events, but when exported to excel, it goes back to only showing each instance once. I know that the concern is that it will generate infinite entries, but is there a way to export this to excel showing all of the recurring items?  I have tried many times and looked on the internet with no success.  So far I'm only using the included parts of sharepoint, so I haven't looked into 3rd party software or writing my own code. Any help is appreciated, Thanks! -Casey

Can´t get the time intelligence filter to work in PerformancePoint Services/Sharepoint

Hi all, I have created a scorecard in Dashboard Designer based on an SSAS cube which looks ok in both DD and Sharepoint. As I want to connect a time filter to this I have created a TI filter in DD. In Sharepoint I have connected the filter to the scorecard with "send performancepoint values to". In "configure connection" I set source value to "PerformancePoint Values: Formula" and Connect to to "Endpoint_TIFormula". I only need to filter on year and have set the TI properties on the cube. Selected time dimension is "Year", Hierarchy level is set to Year, Member is 2008, reference date is 1/1/2008 and I have associated member level Year to Time aggregation Year. The filter is set up like this in DD: it uses the same data source as the scorecard and I use a list view. I do get the filter to work if I specify one formula for each year (e.g. Formula: "Year" and "Display Name: "2010", "Year-1" and "2009" making up two rows) but that can´t be the right way to do it, right? What i would like is a multiselect tree view where I can choose the year I want and have them display on columns. I have tried the formula Year:Year-2 and in the preview I see [Date].[Year].&[2008],[Date].[Year].&[2009],[Date].[Year].&[2008]. However, in Sharepoint the filter only show on

Can not show image in Filter drop down menu in SPGridView - Sharepoint 2007

Hi, I can not show image in the filter drop down menu (at header) of SPGridView in Sharepoint 2007.  For example: I have 3 rows as "_layout/images/1.gif", "_layout/images/2.gif", "_layout/images/3.gif". When user click on the column's header, the SPGridView just displayed filter menu and it always displayed the text (_layout/images/1.gif) not an image as I expected. So please help me to solve this problem. Thanks a lot Dan

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

Sharepoint Filter Web Part Connection to Picture Libary Web Part

It seems that a sharepoint or choice filter web part can connect to any list object in sharepoint that is displayed in a web part on a page but the picture library.  I want to allow the user to select a value so that only the image that applies is viewed (along with any correlating information stored in its library). Is there a work around for this?  I've looked all over the web and can only find where someone else has asked in another forum and has not yet received an answer.  I'm sure this isn't the first time this has come up, so what are folks doing to accomplish this?

How to remove conflict between Sharepoint 2010 Post Cache Substitution and Response.Filter

Under SharePoint 2007 (Win Server 2008, SQL 2008) we made use of Response.Filter to meet certain requirements for accessibility to remove certain markup or add to markup that was missing attributes, etc. When we upgraded to SharePoint 2010 we get the following error message from the pages, unless we remove the use of Response.Filter: "Post cache substitution is not compatible with modules in the IIS integrated pipeline that modify the response buffers.  Either a native module in the pipeline has modified an HTTP_DATA_CHUNK structure associated with a managed post cache substitution callback, or a managed filter has modified the response." I have found several posts including this article http://support.microsoft.com/kb/2014472 that explains that it is definately a problem, but no one has an alternative solution to using the Response.Filter, and the article doesn't say how to disable the use of Post Cache Substitution. So, my question is how do I turn off the use of Post Cache Substitution in SharePoint 2010, or how can I alter the final markup of the page "After" the substitution happens?  Or, if it is a control or three that are using Post Cache Substitution, which one(s) so that I can remove them.

Parameter value filter based on user in SSRS (SharePoint Integration mode)


Hello..we have a reuirement where we have to filter the parameter value in the drop down based on the user who is accessing the report. We have form and Windows authenication enabled in the SharePoint site (some users will be from inside the network using windows and some will be accessing the site using internet using the Form Authentication).

Please let me know what would be the best way to handle this reuirement? Do we need to create a separate table  and store the User Information along with the parameter values they have access to, pass the userid from Report to db and then fileter the records using this table? OR Can we create a SharePoint List to maintain the user access information and then directly fetch the user information from the list using T-SQL to filter the records?

Please let me know your suggestion...


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