Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsLimited number of sub calendars?Limited number of sub calendars?
Previous
 
Next
New Post
10/19/2009 2:54 PM
 

OK, this sounds great even if I don't understand half of this more techical jargon ;-)  I have about 63 sub-calendars visible now so your calculation is right. I would gladly like to try your solution. Maybe someone else could use it, too. So can you publish it here or somewhere else?

Thank you very much, Roger!

Regards,

timov.

 
New Post
10/19/2009 4:38 PM
 

What version of the module are you currently using? I need this so as to give a fix relevant for the version you are using.

Cheers
Roger


DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
10/19/2009 5:22 PM
 

I'm using now version 5.0.2. I think the new 5.0.3 Beta wouldn't solve the problem, would it?

Regards,

timov.

 
New Post
10/20/2009 2:49 AM
 

No 5.0.3 wouldn't fix it.

The following SQL run in the Host/SQL dialogue should fix it (Tick execute as script). That said, I haven't tested this since I'm not keen to create 60-70 calendars to try it out.

/*** EventsGetByRange ***/

ALTER PROCEDURE {databaseOwner}{objectQualifier}EventsGetByRange

(

@Filter nvarchar(1000),

@BeginDate datetime,

@EndDate datetime

)

AS

SET DATEformAT mdy

Declare @sql nvarchar(4000)

Select @sql = 'SELECT E.PortalID, E.EventID, E.RecurMasterID, E.ModuleID, E.EventDateBegin, E.EventDateEnd, '

+ 'E.EventTimeBegin, E.Duration, E.EventName, E.EventDesc, '

+ 'E.Importance, E.CreatedDate, '

+ 'CreatedBy = U.DisplayName, '

+ 'CreatorID = E.CreatedBy, '

+ 'E.Every, '

+ 'E.Period, '

+ 'E.RepeatType, '

+ 'E.Notify, '

+ 'E.approved, '

+ 'E.Signups, '

+ 'E.MaxEnrollment, '

+ '(Select count(*) from {databaseOwner}{objectQualifier}EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, '

+ '(Select count(*) from {databaseOwner}{objectQualifier}Events as E2 WHERE E2.RecurMasterID = E.RecurMasterID and E2.Cancelled = 0 and E2.Approved = 1) as NoOfRecurrences, '

+ '(Select max(EventDateBegin) from {databaseOwner}{objectQualifier}Events as E2 WHERE E2.RecurMasterID = E.RecurMasterID and E2.Cancelled = 0 and E2.Approved = 1) as LastRecurrence, '

+ 'E.EnrollRoleID, '

+ 'E.EnrollFee, '

+ 'E.EnrollType, '

+ 'E.PayPalAccount, '

+ 'E.PayPalPassword, '

+ 'E.Cancelled, '

+ 'E.DetailPage, '

+ 'E.DetailNewWin, '

+ 'E.DetailURL, '

+ 'E.ImageURL, '

+ 'E.ImageType, '

+ 'E.ImageWidth, '

+ 'E.ImageHeight, '

+ 'E.ImageDisplay, '

+ 'E.Location, '

+ 'c.LocationName, '

+ 'c.MapURL, '

+ 'E.Category, '

+ 'b.CategoryName, '

+ 'b.Color, '

+ 'b.FontColor, '

+ 'E.Reminder, '

+ 'E.TimezoneOffset, '

+ 'E.SendReminder, '

+ 'E.ReminderTime, '

+ 'E.ReminderTimeMeasurement, '

+ 'E.ReminderFrom, '

+ 'E.SearchSubmitted, '

+ 'E.CustomField1, '

+ 'E.CustomField2, '

+ 'E.EnrollListView, '

+ 'E.DisplayEndDate, '

+ 'E.AllDayEvent, '

+ 'E.OwnerID, '

+ 'OwnerName = O.DisplayName, '

+ 'E.LastUpdatedAt, '

+ 'LastUpdatedBy = L.DisplayName, '

+ 'E.LastUpdatedID, '

+ '(Select ModuleTitle from {databaseOwner}{objectQualifier}Modules WHERE ModuleID = E.ModuleID) as ModuleTitle, '

+ 'RMOwnerID = r.OwnerID, '

+ 'r.RRULE, '

+ 'E.OriginalDateBegin, '

+ 'E.NewEventEmailSent '

+ 'FROM {databaseOwner}{objectQualifier}Events E '

+ 'inner join {databaseOwner}{objectQualifier}EventsRecurMaster AS r on E.RecurMasterID = r.RecurMasterID '

+ 'left outer join {databaseOwner}{objectQualifier}Users U on E.CreatedBy = U.UserID '

+ 'left outer join {databaseOwner}{objectQualifier}Users O on E.OwnerID = O.UserID '

+ 'left outer join {databaseOwner}{objectQualifier}Users L on E.LastUpdatedID = L.UserID '

+ 'left join {databaseOwner}{objectQualifier}EventsCategory b on E.Category = b.Category '

+ 'left join {databaseOwner}{objectQualifier}EventsLocation c on E.Location = c.Location '

+ 'WHERE ((E.EventTimeBegin <= DATEADD(DAY,1,''' + convert(varchar, @EndDate) + ''') AND DATEADD(minute,E.Duration,E.EventTimeBegin) >= ''' + convert(varchar, @BeginDate) + ''') OR '

+ ' (E.EventTimeBegin BETWEEN ''' + convert(varchar, @BeginDate) + ''' AND DATEADD(DAY,1,''' + convert(varchar, @EndDate) + '''))) '

+ ' AND E.Approved = 1'

+ ' AND E.Cancelled = 0'

+ ' ' + @Filter + ' '

+ ' ORDER BY E.EventDateBegin, E.EventTimeBegin, E.EventDateEnd'

EXEC (@sql)

GO


DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
10/20/2009 2:51 AM
 

For those interested... In 5.0.2 the procedure uses dynamic SQL. In 5.0.3 this has been replaced with static SQL to improve performance and avoid some of the other potential issues with dynamic SQL.

Roger


DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsLimited number of sub calendars?Limited number of sub calendars?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out