Change Diary View Date Range (TeamSport)

Change Diary View Date Range (TeamSport)

If Team Sport ever asks to change the Date Range in their Diary there is a query you can ran that will need to be modified slightly in order to accommodate the date range they are requesting.

First and foremost take a back up of their database to ensure that if something goes wrong we can revert.

Then Run this Query in ClubSpeedV8:

ALTER PROCEDURE [dbo].[RefreshDSEventScheduling]
AS
SELECT ID, TypeID, Description, Subject, Status, Label, StartTime, EndTime, ID as EventReservationID,
Description as OrgDescription, Subject as OrgSubject, Label OrgLabel,
StartTime OrgStartTime, EndTime OrgEndTime,Notes, MainID
FROM EventReservations
WHERE DELETED = 0 AND StartTime > dateadd(dd,-8,getdate())

Depending on what date range they are looking for the area you will be modifying is StartTime > dateadd(dd,-8,getdate())
the '8' is the number of days it will show in the Diary and that is the number you will modify depending on what they are requesting.

If you run into any issues just let level 2 or Shingo know.

Related Articles