USP_DATALIST_FEEDALERTINSTANCE_APPUSERS

Returns the users assigned to a custom email alert instance.

Parameters

Parameter	Parameter Type	Mode	Description
@INSTANCEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                create procedure dbo.USP_DATALIST_FEEDALERTINSTANCE_APPUSERS
                (
                    @INSTANCEID uniqueidentifier
                )
                as
                set nocount on;

                select 
                    APPUSERFEEDALERTINSTANCE.ID,
                    APPUSER.ID as [APPUSERID],
                    APPUSER.DISPLAYNAME,
                    APPUSER.USERNAME,
                    coalesce((select top 1 APPUSERALERTSETTING.EMAILADDRESS from dbo.APPUSERALERTSETTING where APPUSERALERTSETTING.ID = APPUSER.ID), N'') as [EMAILADDRESS]
                from APPUSERFEEDALERTINSTANCE
                inner join dbo.APPUSER on APPUSER.ID = APPUSERFEEDALERTINSTANCE.APPUSERID
                where APPUSERFEEDALERTINSTANCE.FEEDALERTINSTANCEID = @INSTANCEID