ECIA NSW > Learning > Event Calendar

Search


Submit

Submit

Finance and Operations Sustainability Workshop Register Now Monday May 21 2018 09:15 till 16:15

Standard Loaded -
Security - Edit Roles set to
Security - Add Roles set to
Security - Delete Roles set to
Standard Alternate Loaded -
Executed SQL - Select Event.EventId ,[Event Name] ,DATENAME(dw, [Event Start Date])+ ' ' + DATENAME(mm, [Event Start Date]) + ' ' + DATENAME(d, [Event Start Date]) + ' ' + DATENAME(YYYY, [Event Start Date]) AS [Event Start Date] ,[Event Start Time] ,[Event End Time] ,CASE WHEN (RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees) THEN 'SOLD OUT' WHEN Event.EventStatus = 'Closed' THEN 'Phone for Last Seats or Changes' ELSE 'Register Now' END AS [Booking URL] ,CASE WHEN PublicBookingFormHeader LIKE '%
' THEN LEFT(PublicBookingFormHeader, LEN(PublicBookingFormHeader)-4) ELSE PublicBookingFormHeader END AS PublicBookingFormHeader FROM EventData INNER JOIN Event ON EventData.[Event Id] = Event.EventId left outer join ( select EventRegistrationType.EventId, COUNT(1) as NoAttendees from EventAttendee inner join EventRegistration on EventAttendee.EventRegistrationId = EventRegistration.EventRegistrationId inner join EventRegistrationType on EventRegistration.EventRegistrationTypeId = EventRegistrationType.EventRegistrationTypeId where PrimaryEvent = 1 group by EventRegistrationType.EventId ) attendeeNumbers on Event.EventId = attendeeNumbers.EventId WHERE AvailableOnline = 1 AND [Event Start Date] > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) order by Event.StartDate ASC

Select rows above and then selection an action from below to execute on your data:

Execute Selected Action

Event Id	Event Name	Event Start Date	Event Start Time	Event End Time	Booking URL	Public Booking Form Header

13	Finance and Operations Sustainability Workshop	Monday May 21 2018	09:15	16:15	Register Now

Event Calendar

Finance and Operations Sustainability Workshop