QLD BDPS WEBINAR - 15 OCTOBER 2020
Thursday October 15 2020
Book Now
Standard Loaded -
Security - Edit Roles set to
Security - Add Roles set to
Security - Delete Roles set to
Standard Alternate Loaded -
Executed SQL - SELECT EventId,EventName,EventTypeName,EventGroupName,OrganiserEmail,OrganiserName,OrganiserPhone,VenueName,VenueEmail,VenuePhone,VenueHyperLink,CancellationPolicy,FreeEvent,AvailableOnline,EventStatus,RegistrationLimit,ShowDescriptionOnline,TimeZone,BranchName,VenueAddress,StartDate, StartDateString,StartTime,EndDate, EndDateString,EndTime,OptionsOnlyAttendeeCount,PrimaryAttendeeCount,TotalAttendeeeCount,BookingURL,ButtonClass,ButtonText,PublicBookingFormHeader
FROM DNNEventData
WHERE
[EventStatus] = 'Open'
AND AvailableOnline = 1
AND [StartDate] >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE()))
order by [StartDate] ASC
Select rows above and then selection an action from below to execute on your data:
Execute Selected Action