|
|
|
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
Previous Page | Next Page