USP_DATALIST_APPUSERFEEDALERT

Returns a list of all of the feed alerts a user is subscribed to.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_APPUSERFEEDALERT
                (
                    @APPUSERID uniqueidentifier
                ) as
                begin
                    set nocount on;

                    select
                        APPUSERFEEDALERTINSTANCE.ID,
                        ALERTTYPE.NAME [ALERTTYPE],
                        FEEDALERTINSTANCE.NAME [ALERTNAME],
                        case when FEEDALERTINSTANCE.ISUSERINSTANCE = 0 then 1 else 0 end as [ISSYSTEMINSTANCE],
                        FEEDALERTINSTANCE.ID as [FEEDALERTINSTANCEID],
                        FEEDALERTINSTANCE.ISENABLED,
                        ALERTTYPE.ID [ALERTID]
                    from dbo.APPUSERFEEDALERTINSTANCE
                    inner join dbo.FEEDALERTINSTANCE on FEEDALERTINSTANCE.ID = APPUSERFEEDALERTINSTANCE.FEEDALERTINSTANCEID
                    inner join dbo.ALERTTYPE on ALERTTYPE.ID = FEEDALERTINSTANCE.ALERTTYPEID
                    where APPUSERFEEDALERTINSTANCE.APPUSERID = @APPUSERID
                    order by
                        ALERTTYPE.NAME asc, FEEDALERTINSTANCE.NAME asc        

                end