USP_EXCHANGECALENDARSYNC_GETPARAMETERS

Returns parameter settings for a given calender item synchronization parameter set.
Parameters

Parameter	Parameter Type	Mode	Description
@PARAMETERSETID	uniqueidentifier	IN
Definition

Copy


            CREATE procedure dbo.USP_EXCHANGECALENDARSYNC_GETPARAMETERS
            (
                @PARAMETERSETID uniqueidentifier
            )
            as
                set nocount on;

                select
                    EXCHANGECALENDARSYNC.APPUSERIDSETREGISTERID,
                    EXCHANGECALENDARSYNC.LASTRUNON,
                    EXCHANGECALENDARSYNC.CREATEITEMOPTIONCODE,
                    EXCHANGECALENDARSYNC.EXPECTEDDATEINTERVALCODE,
                    --adding case for backwards compat

                    --EXCHANGECALENDARSYNC.INTERACTIONFILTERCODE,

                    case 
                        when EXCHANGECALENDARSYNC.INCLUDEPENDINGINTERACTIONS = 1 and  EXCHANGECALENDARSYNC.INCLUDEPROSPECTPLANSTEPS = 1 then 2
                        when EXCHANGECALENDARSYNC.INCLUDEPENDINGINTERACTIONS = 0 and  EXCHANGECALENDARSYNC.INCLUDEPROSPECTPLANSTEPS = 1 then 1
                        else 0 end as INTERACTIONFILTERCODE,
                    EXCHANGECALENDARSYNC.SPECIFICAPPUSERID,
                    EXCHANGECALENDARSYNC.APPLYTOCODE,
                    EXCHANGECALENDARSYNC.NAME,
                    EXCHANGECALENDARSYNC.DESCRIPTION,
                    EXCHANGECALENDARSYNC.PAGEDEFINITIONCATALOGID,
                    EXCHANGECALENDARSYNC.CREATEDEFAULTREMINDER,
                    EXCHANGECALENDARSYNC.DEFAULTREMINDERAMOUNT
                from
                    dbo.EXCHANGECALENDARSYNC
                where
                    EXCHANGECALENDARSYNC.ID = @PARAMETERSETID;