USP_EXCHANGECALENDARSYNC_GETCALENDARINFORMATION

Returns information to be used in the calendar item synchronization process for a given interaction.

Parameters

Parameter	Parameter Type	Mode	Description
@INTERACTIONID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_EXCHANGECALENDARSYNC_GETCALENDARINFORMATION
            (
                @INTERACTIONID uniqueidentifier
            )
            as
                set nocount on;

                select 
                    INTERACTION.ID, 
                    INTERACTION.OBJECTIVE as SUBJECT, 
                    INTERACTION.EXPECTEDDATE,
                    dbo.UFN_CONSTITUENT_BUILDNAME(INTERACTION.CONSTITUENTID) as CONSTITUENTNAME,
                    INTERACTION.EXPECTEDSTARTDATETIME,
                    INTERACTION.EXPECTEDENDDATETIME,
                    INTERACTION.TIMEZONEENTRYID,
                    (select TIMEZONEENTRY.NAME from dbo.TIMEZONEENTRY where TIMEZONEENTRY.ID = INTERACTION.TIMEZONEENTRYID) as TIMEZONE,
                    INTERACTION.ISALLDAYEVENT
                from
                    dbo.INTERACTION
                where
                    INTERACTION.ID = @INTERACTIONID;