Register
|
Login
Search
Search
Home
About us
Our story
Our Strategic Plan
Our members
Our Board
Presidents' reports
Our staff
John Shaw Medal
Ray Fisher Technical Excellence Award
Membership
Events
Upcoming events
Sponsorship
Past events
Industry training
Policy
About RA Policy
Sustainability
Presentations and reports
Transport Reform
Presentations and reports
Driverless Study Visit Links
Customer Experience
Presentations and reports
Capacity
Presentations and reports
National Road Safety Barrier Accreditation
Safety
Presentations and reports
RA Submissions
RA Policy Insights
News
Media releases
Roads Australia Insider
Podcasts
RA Reports and Publications
Future Leaders
Fellowship Program
About the Fellowship Program
Chapter News
Resources
Fellows Council
Research projects
Emerging Leaders Program
Diversity
Pipeline
About the Pipeline
Projects - next 12 months
Projects - 12 months +
Contact Us
You are here:
Events
>>
Event Details
Back
Roads Australia Event Details
Search
Submit
RA CEO Workshop (Sydney)
16/06/2021 16:00 to 16/06/2021 18:00
Venue:
Fullerton Hotel
Details:
BY INVITATION
Register Now
Name
Event Start Date
Start Time
Event End Date
End Time
Venue
Event Description
Booking URL
Event Id
RA CEO Workshop (Sydney)
16/06/2021
16:00
16/06/2021
18:00
Fullerton Hotel
BY INVITATION
Register Now
3264
Dynamic Loaded -
Select Name ,CONVERT(VARCHAR(12),Event.StartDate,103) AS EventStartDate ,StartTime ,CONVERT(VARCHAR(12),event.EndDate,103) AS EventEndDate ,EndTime ,Venue ,EventDescription ,CASE WHEN EventStatus = 'Open' AND AvailableOnline = 1 AND StartDate > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) THEN CASE WHEN RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees THEN '
SOLD OUT
' ELSE '
Register Now
' END WHEN Event.HtmlGalleryLink IS NOT NULL AND Event.HtmlGalleryLink <> '' THEN '
Image Gallery
' ELSE '' END AS BookingURL ,Event.EventId FROM Event left outer join ( select EventRegistrationType.EventId as Eid, 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.Eid WHERE Event.EventId = [QRY-EventId] AND EventStatus <> 'Pending'
Dynamic Alternate Loaded -
Security -
Edit Roles set to
Security -
Add Roles set to
Security -
Delete Roles set to
Using Existing Dynamic Set -
Select Name ,CONVERT(VARCHAR(12),Event.StartDate,103) AS EventStartDate ,StartTime ,CONVERT(VARCHAR(12),event.EndDate,103) AS EventEndDate ,EndTime ,Venue ,EventDescription ,CASE WHEN EventStatus = 'Open' AND AvailableOnline = 1 AND StartDate > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) THEN CASE WHEN RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees THEN '
SOLD OUT
' ELSE '
Register Now
' END WHEN Event.HtmlGalleryLink IS NOT NULL AND Event.HtmlGalleryLink <> '' THEN '
Image Gallery
' ELSE '' END AS BookingURL ,Event.EventId FROM Event left outer join ( select EventRegistrationType.EventId as Eid, 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.Eid WHERE Event.EventId = [QRY-EventId] AND EventStatus <> 'Pending'
Executed SQL -
Select Name ,CONVERT(VARCHAR(12),Event.StartDate,103) AS EventStartDate ,StartTime ,CONVERT(VARCHAR(12),event.EndDate,103) AS EventEndDate ,EndTime ,Venue ,EventDescription ,CASE WHEN EventStatus = 'Open' AND AvailableOnline = 1 AND StartDate > DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE())) THEN CASE WHEN RegistrationLimit is not null and RegistrationLimit > 0 and RegistrationLimit <= attendeeNumbers.NoAttendees THEN '
SOLD OUT
' ELSE '
Register Now
' END WHEN Event.HtmlGalleryLink IS NOT NULL AND Event.HtmlGalleryLink <> '' THEN '
Image Gallery
' ELSE '' END AS BookingURL ,Event.EventId FROM Event left outer join ( select EventRegistrationType.EventId as Eid, 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.Eid WHERE Event.EventId = 3264 AND EventStatus <> 'Pending' AND EventId LIKE '%3264%'
Select rows above and then selection an action from below to execute on your data:
Copy Record
Execute Selected Action