program controls


morning presentations

Morning Presentations

Error compiling Razor Template: Failed to execute sql SELECT [ArticleType] ,[SessionId] ,[Type] ,[Location] ,[Title] ,[Description] ,[HostAuthors] ,[TrueStartDate] ,[TrueEndDate] ,[Block] ,[Convention] , CONVERT(CHAR(5), [TrueStartDate], 108) AS MILITARY_TIME , FORMAT([TrueStartDate], 't') AS START_TIME , FORMAT([TrueEndDate], 't') AS END_TIME , FORMAT([TrueStartDate], 'dddd, dd MMMM, yyyy') AS DAY_AND_DATE , FORMAT([TrueStartDate], 'dd MMMM, yyyy') AS JUST_DATE , FORMAT([TrueStartDate], 'dddd') + ' ' + [Type] + ' Sessions' AS DAY_SESSION_TYPE , [TeamPresentation] AS isTeam ,COALESCE([EABS], '') as 'EABS' FROM [dbo].[aapg_vw_Session_Details_ICE] WHERE Convention = 'CIE19BA' AND (('2019-08-29' = '') OR (DATEADD(dd, DATEDIFF(d, 0, [TrueStartDate]), 0)='2019-08-29')) AND (('Poster' = '') OR ([Type] = 'Poster')) AND (('AM' = '') OR ([Block]='AM')) Order by SessionId, Articletype desc, TruesTARTDate, CONVERT(int, abstractSort), Title (check logs for more details)

afternoon presentations

Afternoon Presentations

Error compiling Razor Template: Failed to execute sql SELECT [ArticleType] ,[SessionId] ,[Type] ,[Location] ,[Title] ,[Description] ,[HostAuthors] ,[TrueStartDate] ,[TrueEndDate] ,[Block] ,[Convention] , CONVERT(CHAR(5), [TrueStartDate], 108) AS MILITARY_TIME , FORMAT([TrueStartDate], 't') AS START_TIME , FORMAT([TrueEndDate], 't') AS END_TIME , FORMAT([TrueStartDate], 'dddd, dd MMMM, yyyy') AS DAY_AND_DATE , FORMAT([TrueStartDate], 'dd MMMM, yyyy') AS JUST_DATE , FORMAT([TrueStartDate], 'dddd') + ' ' + [Type] + ' Sessions' AS DAY_SESSION_TYPE , [TeamPresentation] AS isTeam ,COALESCE([EABS], '') as 'EABS' FROM [dbo].[aapg_vw_Session_Details_ICE] WHERE Convention = 'CIE19BA' AND (('2019-08-29' = '') OR (DATEADD(dd, DATEDIFF(d, 0, [TrueStartDate]), 0)='2019-08-29')) AND (('Poster' = '') OR ([Type] = 'Poster')) AND (('PM' = '') OR ([Block]='PM')) Order by SessionId, Articletype desc, TruesTARTDate, CONVERT(int, abstractSort), Title (check logs for more details)