2024 QLD Annual Christmas Networking Drinks
An APIG QLD Event
04/12/2024 17:00 to 04/12/2024 21:00
Venue: Naldam House, Felix Street, BRISBANE, QLD, 4000, AUSTRALIA,
Details:
Book Here
APIG QLD | 2024 QLD Annual Christmas Networking Drinks | 04/12/2024 | 17:00 | 04/12/2024 | 21:00 | Naldam House | Felix Street, BRISBANE, QLD, 4000, AUSTRALIA, | | https://apig.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=260 | 260 |
Dynamic Loaded -
Select
'APIG ' + ISNULL(Branch.Name, '') as [Branch Name]
,[Event Name]
,CONVERT(VARCHAR(12),[Event Start Date],103) AS [Event Start Date]
,[Event Start Time]
,CONVERT(VARCHAR(12),[Event End Date],103) AS [Event End Date]
,[Event End Time]
,[Event Venue]
,[Event Venue Address]
,[Event Description]
,'https://apig.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=' + CAST([Event Id] AS VARCHAR(5)) AS [Booking URL]
,EventId
FROM EventData
INNER JOIN Event ON EventData.[Event Id] = Event.EventId
LEFT OUTER JOIN Branch ON EVENT.BranchId = Branch.BranchId
WHERE [Event Status] = 'Open'
AND AvailableOnline = 1
Dynamic Alternate Loaded -
Security - Edit Roles set to
Security - Add Roles set to
Security - Delete Roles set to
Using Existing Dynamic Set -
Select
'APIG ' + ISNULL(Branch.Name, '') as [Branch Name]
,[Event Name]
,CONVERT(VARCHAR(12),[Event Start Date],103) AS [Event Start Date]
,[Event Start Time]
,CONVERT(VARCHAR(12),[Event End Date],103) AS [Event End Date]
,[Event End Time]
,[Event Venue]
,[Event Venue Address]
,[Event Description]
,'https://apig.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=' + CAST([Event Id] AS VARCHAR(5)) AS [Booking URL]
,EventId
FROM EventData
INNER JOIN Event ON EventData.[Event Id] = Event.EventId
LEFT OUTER JOIN Branch ON EVENT.BranchId = Branch.BranchId
WHERE [Event Status] = 'Open'
AND AvailableOnline = 1
Executed SQL -
Select
'APIG ' + ISNULL(Branch.Name, '') as [Branch Name]
,[Event Name]
,CONVERT(VARCHAR(12),[Event Start Date],103) AS [Event Start Date]
,[Event Start Time]
,CONVERT(VARCHAR(12),[Event End Date],103) AS [Event End Date]
,[Event End Time]
,[Event Venue]
,[Event Venue Address]
,[Event Description]
,'https://apig.memnet.com.au/MemberSelfService/EventBooking.aspx?selectedEventId=' + CAST([Event Id] AS VARCHAR(5)) AS [Booking URL]
,EventId
FROM EventData
INNER JOIN Event ON EventData.[Event Id] = Event.EventId
LEFT OUTER JOIN Branch ON EVENT.BranchId = Branch.BranchId
WHERE [Event Status] = 'Open'
AND AvailableOnline = 1 AND EventId LIKE '%260%'
Select rows above and then selection an action from below to execute on your data:
Execute Selected Action