USP_DATALIST_EXCHANGECONTACTSYNC

Returns a list of Exchange contact synchronization process parameter sets.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                    create procedure dbo.USP_DATALIST_EXCHANGECONTACTSYNC
                    (
                        @CURRENTAPPUSERID uniqueidentifier = null
                    )
                    as
                        set nocount on;

                        select
                            EXCHANGECONTACTSYNC.ID,
                            EXCHANGECONTACTSYNC.NAME,
                            EXCHANGECONTACTSYNC.DESCRIPTION,
                            dbo.UFN_EXCHANGECONTACTCATEGORYCODE_GETDESCRIPTION(EXCHANGECONTACTSYNC.EXCHANGECONTACTCATEGORYCODEID),
                            EXCHANGECONTACTSYNC.LASTRUNON,
                            BPI.OWNERID as OWNERID
                        from
                            dbo.EXCHANGECONTACTSYNC
                            left join dbo.BUSINESSPROCESSINSTANCE BPI on EXCHANGECONTACTSYNC.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                        where 
                            dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, EXCHANGECONTACTSYNC.ID) = 1
                        order by
                            EXCHANGECONTACTSYNC.NAME