Register  |  Login
  Information > DNN Blog > DNN Events
DotNetNuke Blog

Current Articles | Categories | Search | Syndication

Event enrollments need to be retrieved for sub-calendars

Prior to version 4.0.0, event enrollments were being retrieved for the whole portal. This is incorrect and should be linked at least to the module being viewed. However, the change made, meant that only enrollments for the current calendar and not it's sub-calendars were being displayed. This requires a minor SPROC change to EventsSignupsMyEnrollments. Basically this makes it check whether the ModuleID (@ModuleID) passed appears in EventsMaster (e.ModuleID) linked to a sub-calendar with a ModuleID (e.SubEventID) the same as the one in the EventsSignups (s.ModuleID) table.

from dbo.EventsSignups s
   Left Join dbo.Users u ON s.UserID = u.UserID
   Left Join dbo.Modules m on m.ModuleID = s.ModuleID
   Left Join dbo.TabModules x on m.ModuleID = x.ModuleID
   Left Join dbo.Tabs t on t.TabID = x.TabID
   Left Join dbo.Events c ON s.EventID = c.EventID
   Left Outer Join dbo.EventsMaster e ON s.ModuleID = e.SubEventID
Where  s.Userid = @UserID AND (s.ModuleID = @ModuleID Or e.ModuleID = @ModuleID)
ORDER BY s.EventtimeBegin desc

posted @ 17 July 2008 08:46 by Roger Selwyn

Previous Page | Next Page

COMMENTS

Name (required)

Email (required)

Website

CAPTCHA image
Enter the code shown above: